Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have create a matrix table which shows all the measures in column 1 (most of them are simple SUM measures). Then from 2 to 13 columns I have set all months from Jul to Jun (Fiscal Year).
What I want to do is to add another 3 columns, showing:
- Column 14: Instead of Grand Total I want to show YTD - Current year
- Columns 15: PYTD - previous year
- Column 16: YTD vs PYTD - Variance
I am able to build a comparative YTD vs PYTD table, but not a combination of montly, ytd and pytd.
I am a newbie in Power BI so I´m a little bit lost. Any tips to help me to move forward?
Many thanks in advance for your help.
Cheers
Solved! Go to Solution.
Hi @underkar,
I'm afraid it is not available to replace the Grand Total column with YTD, PYTD and YTD vs PYTD. Even you have generated the correct measures for these three values, when you add them to Matrix, they will be displayed under each Month column header (looks like a column group), rather then appending to the right of the last month column.
Regards,
Yuliana Gu
Hi @underkar
The below link will solve your problem. It has been done for Previous YTD and % Change and you can change the metrics for as per your need.
Hi @underkar,
I'm afraid it is not available to replace the Grand Total column with YTD, PYTD and YTD vs PYTD. Even you have generated the correct measures for these three values, when you add them to Matrix, they will be displayed under each Month column header (looks like a column group), rather then appending to the right of the last month column.
Regards,
Yuliana Gu
WHoa! I don't think that's possible without making all sorts of measures. It will be interest ing to see if someone takes the challenge.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |