Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Please help.
Solved! Go to Solution.
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
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |