FunkyFunktionFriday: Part 2/3: PowerQuery, IF Statements & Custom Columns
Continuing from last week’s FunkyFunktionFriday, we expand on the Full Outer Join and I show you how to write IF statements in the PowerQuery (Get & Transform) editor.
You’ll see how to add a custom column, do more data shaping and boost your overall familiarity with the gifts that continue to flow from PowerQuery.
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My blog: http://datascopic.net/blog2-2