Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Basically the title says it all. I want to get the MAX and MIN values for each day of a given variable.
Can i create this measure?
Thanks in advance,
Ivan
Solved! Go to Solution.
Hi @Anonymous
If I understand you correctly, you could create measures to calculate the max/min value each day.
min = CALCULATE(MIN('Table'[value]),ALLEXCEPT('Table','Table'[date]))
max = CALCULATE(MAX('Table'[value]),ALLEXCEPT('Table','Table'[date]))
Hi @Anonymous
If I understand you correctly, you could create measures to calculate the max/min value each day.
min = CALCULATE(MIN('Table'[value]),ALLEXCEPT('Table','Table'[date]))
max = CALCULATE(MAX('Table'[value]),ALLEXCEPT('Table','Table'[date]))
Yes. The SUMMARIZE function will help.
Your measure would look something like: SUMMARIZE(Table Name, Date Column, MAX(Value Column))
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |