Calculate differance between min and max for value for each date

[Anonymous]

I have the following table and want to calculate the difference for each date.

How do I do this in a measure?

First date should be: 20

Second date should be: 60

Time	Value	Category 1
2022-01-01	50	A
2022-01-01	30	A
2022-01-01	45	B
2022-01-01	47	B
2022-01-02	51	A
2022-01-02	52	A
2022-01-02	70	A
2022-01-02	20	B
2022-01-02	22	B
2022-01-02	10	C
2022-01-03	14	A

[DOLEARY85]

Hi,

try this:

Measure 4 = var _min = CALCULATE(min('Table (4)'[Value]),ALLEXCEPT('Table (4)','Table (4)'[Time]))

var _max = CALCULATE(max('Table (4)'[Value]),ALLEXCEPT('Table (4)','Table (4)'[Time]))

return

CALCULATE(sum('Table (4)'[Value]),'Table (4)'[Value]=_max)-CALCULATE(sum('Table (4)'[Value]),'Table (4)'[Value]=_min)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍