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,
Can you please help me to show the Quater starting month value(MeasureA-2817) in the Quarter summary (Q1) as highlighted in the below table please. This table is derived in excel and i am trying to replicate in Power BI.
Month/Year | MeasureA | MeasureB | MeasureC | MeasureD | MeasureE | MeasureF |
1/1/2022 | 2817 | 98 | 176 | 2739 | 6% | 4% |
2/1/2022 | 2739 | 217 | 147 | 2809 | 5% | 8% |
3/22/2022 | 2809 | 221 | 167 | 2863 | 6% | 8% |
Q1 2022 | 2817 | 536 | 490 | 2863 | 17% | 19% |
4/22/2022 | 2863 | 200 | 165 | 2898 | 6% | 7% |
5/22/2022 | 2898 | 280 | 160 | 3018 | 5% | 9% |
6/22/2022 | 3018 | 214 | 104 | 3128 | 3% | 7% |
Q2 2022 | 2863 | 694 | 429 | 3128 | 14% | 23% |
Please help, Thanks
Solved! Go to Solution.
@lbendlin - This is what I was expecting. Thanks a ton for this help. Really you are awesome !!
This is bad UX, don't do it. Use a calendar table instead, and a matrix visual.
@lbendlin - Sorry as I am new bee, I dint get your suggestion.
I have the above table in excel as a sample which I need to replicate in power BI. I am using Matrix view already to create the view but not sure how to replicate the Quater level sum with month level data.
Can you please ellaborate a bit more .
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |