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,
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |