<<Was able to solve this by using All Selected explained in Matt's Supercharge PowerBI. In case, anyone is trying to solve the same problem.>>
Please see tab YTD% of Selected Columns.
I am exploring whether there is a benefit to changing the computation I currently do in Excel to Power Query and use DAX instead of calculating the formulas in excel.
I have attached the file.
I have 3 sub teams with expense categories. I calculate expense category as a percentage of both the total expenses for the whole team (A, B and C)
as well as percentage for each sub team.
Is there a benefit to converting this to do the computation in DAX and if yes what formula should I use?
Thanks in advance for any help.
A dedicated forum to help people when working through the book "Learn to Write DAX"
1 post • Page 1 of 1
Who is online
Users browsing this forum: Google [Bot] and 1 guest