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.
I have the following matrix with fiscal quarter and month in the columns. (Just noticed months are out of order, but I'll fix that separately.) My client would like to see all 12 monthly totals next to each other, followed by the 4 quarter (FQ) totals, then the year (FY) total. Is it possible to group all the FQ totals together after the months?
Solved! Go to Solution.
@carinalou , I doubt that.
For that we create a new table. where have month year, month, qtr and year , final name
This will have data for a month with the month as the final name
then you need to repeat the same data with Qtr as the final name
then you will append same data year as final name
Join this with your date table many to many join filter your date table
I have added a sample file after the signature. In case you year to separate out take a year on column too
@carinalou , I doubt that.
For that we create a new table. where have month year, month, qtr and year , final name
This will have data for a month with the month as the final name
then you need to repeat the same data with Qtr as the final name
then you will append same data year as final name
Join this with your date table many to many join filter your date table
I have added a sample file after the signature. In case you year to separate out take a year on column too
Thanks so much for your help!
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |