Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |