How to show Quarter first month value as Quarter Summary

[Anonymous]

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

[Anonymous]

@lbendlin  - This is what I was expecting. Thanks a ton for this help. Really you are awesome !!

[Anonymous]

@amitchandak - Can you please on my requirement. Thanks in advance

[Anonymous]

Hi @tamerj1 @SpartaBI @ray_ux @lbendlin Please help me with my above requirement . I am new bee and looking for a desperate help . Thanks in advance

Topic: How to show Quarter first month value as Quarter Summary

[lbendlin]

This is bad UX, don't do it. Use a calendar table instead, and a matrix visual.

[Anonymous]

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

[lbendlin · Accepted solution]

Something like this.  Still bad UX though.