Forum Discussion
KTP_UBS
Helper I
Helper IAdding new column IF statement in Query table
Hello, I am relatively new to PowerBI and really appreciate it if you could help with my question below: By referring to the excel screenshot below, I would like to add BudgetIndex2 and Budge...
sdjensen
Solution Sage
Solution SageHi,
You can read about if statements in Power Query (Query Editor) in this page: http://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/
However I would recommend that you make these measures in your model instead. If you calculate values like this you will get wrong totals when using the value in your visuals.
sdjensenSolution Sage
Solution SageJust noticed you want to compare values in different rows. Don't really have a solution for that.