Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I need to calculate sum of max values per category, type and selected date (year, month, day, specific period - I have directly related calendar table).
I have tried to do it with summarize function, but it didnot wortk flexibly with calendar.
Could you help me with this task? Thank you in advance
Data example:
Date | Category | Type | Value |
2022-10-01 | A | 1st | 10 |
2022-10-02 | A | 1st | 11 |
2022-10-03 | A | 2st | 12 |
2022-11-10 | B | 2st | 14 |
2022-11-03 | B | 1st | 9 |
2010-10-04 | B | 1st | 2 |
2022-10-03 | A | 1st | 10 |
2022-10-01 | B | 2st | 16 |
2022-10-02 | A | 2st | 18 |
2022-11-03 | B | 2st | 8 |
2022-11-03 | C | 2st | 7 |
2022-11-03 | C | 1st | 3 |
2022-10-01 | C | 1st | 4 |
Solved! Go to Solution.
Measure = Max(main[value])
If your problem is resolved then do hit the like.
Measure = Max(main[value])
If your problem is resolved then do hit the like.
Additional coment, for example:
if i use slicers:
date: october
type: 1st
the sum of max values would be:
A category max = 11
C category max = 4
Sum of max: 11+4 = 15
date | Category | Type | Value |
2022-10-01 | A | 1st | 10 |
2022-10-02 | A | 1st | 11 |
2022-10-03 | A | 1st | 10 |
2022-10-01 | C | 1st | 4 |
HI @KristinaSp ,
try with this, if I understand yout question
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Unfortunately, this formula does not work for me. I have added additional comment about expected result. maybe you could check and will have an idea how to wirte the formula. Thank you for your help!
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |