Page 1 of 1

SOLVED: Calculating Total YTD% and YTD% By Team

Posted: Fri Jan 11, 2019 7:08 am
by Poornimaraman
<<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.