Forum Discussion
Solved
Adding 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...
Hi,
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.
Just noticed you want to compare values in different rows. Don't really have a solution for that.