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.