cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Max Value of each quarter and then sum for each category

Hello Community,

I'm trying to create measures for MAX QTD & Sum of MaxQTD. First For each Name i have to find max value of Enrollment for

each quarter and then i have to do sum of that new measure.

You can see in the above data For Name "ABC" i need get max value for each quarter and if multiple Names appears in same quarter then i have to sum the max QTD.

Desired Output would be MAX QTD and then SUM of MAX QTD is like for

Q1 - 440

Q2 - 400

Q3 - 300

For Q-1 i have only one name i.e "ABC" so the output of MAX QTD & SUM of MAX QTD would be same.

For Q-2 also i have only one name i.e "DEF" so the output of MAX QTD & SUM of MAX QTD would be same.

But For Q-3 i have 2 Names ABC & BCD i have calculate max value of quarter for each Names and then Sum.

Max of each names for Q-3 is 150 each and Sum of max value is 300

1 ACCEPTED SOLUTION
Super User

ahahaha - 2/30/2022  -  nice try.

Based on your sample data the maximum for ABC in Q3 is 200, not 150. So the total is 1190

see attached

Super User

ahahaha - 2/30/2022  -  nice try.

Based on your sample data the maximum for ABC in Q3 is 200, not 150. So the total is 1190

see attached

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors