Forum Discussion
Max Month for Quarter
I can't find this solution anywhere. I have a headcount metric where I want to show the volume by Quarter but I only want to show the value for the last month in that quarter. Example. Jan 2400, Feb 1000, March 2000....normal would give me 5400 for 1st quarter but I need it to show QTR1 as 2000. (Basically looking for a Max month for the quarter). Any suggestions would be greatly appreciated
4 Replies
- Greg_Deckler
Community Champion
That's going to depend on your data, do you have columns that identify Quarter as well as the numeric month? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
v-jiascu-msftMicrosoft Employee
Hi Manitou,
Please share a dummy sample. Maybe this formula could give you some ideas.
Measure = CALCULATE ( SUM ( Table1[Value] ), FILTER ( 'Calendar', 'Calendar'[Date] = MAX ( 'Table1'[Date] ) ) )
Best Regards,
- v-jiascu-msft
Hi Manitou,
I'm facing same issue for max month of quarter.
If you solution could you please share.
Thanks
