Forum Discussion
Adding new column IF statement in Query table
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.
Hello,
Thanks for the sample file.
It works in a way if I pull out the Total Grant and Total Budget from two data sources / tables.
Could you please advise if I would like to add a slicer of Project ID so that when I select a project I could see the total grant and total budget for that particular project?
Please see screenshot for your reference. I don't think I can attach the PB file here in the forum :(
Thanks.
Try adding the project id from the project id table instead of the one from the budget table - The one in the budget table should be hidden in the model since it's only used to create a relationship from the budget table to the project id table.