Forum Discussion
Adding new column IF statement in Query table
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.
Hi,
I have came across the link you suggested before posting the question. The example in the link shows the formula on checking the text range but not comparing values in different rows.
Could you please suggest the formula to use in either Query Editor or using Measure?
Or could you suggest how I could process the following scenario by referring to the screenshot below?
1. A project has one budget but may receive one or more Grant
2. I would like to show chart that compare total grant and total budget of year 2016. By taking the screenshot as an example, the total grant for year 2016 = 75392 and total budget for year 2016 = 553725
Many thanks.