SOLVED: Calculating Total YTD% and YTD% By Team

A dedicated forum to help people when working through the book "Learn to Write DAX"
Posts: 1
Joined: Mon Dec 24, 2018 1:19 am

SOLVED: Calculating Total YTD% and YTD% By Team

Postby Poornimaraman » Fri Jan 11, 2019 7:08 am

<<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.

Return to “Help with the Book "Learn to Write DAX"”

Who is online

Users browsing this forum: No registered users and 0 guests