MAX value for each day trend

[Anonymous]

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

[v-juanli-msft · Accepted 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]))

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JonV]

Yes. The SUMMARIZE function will help.

Your measure would look something like: SUMMARIZE(Table Name, Date Column, MAX(Value Column))