MAX and MIN for runing total

[FZOU]

Hello,

i have 2 tables stock and demand who have relation with a DimDate, in stock table i have a calculated measure (cumulative stock), in demand table i have a calculated measure (cumulative demand), after that i added a new measure Delta which is (Delta=cumulative stock-cumulative demand) until now everything is ok,to resume here is the 3 measures.

-CumStock = CALCULATE(SUM('Stock'[StockVal]),FILTER(ALLSELECTED(DimDate),DimDate[Date]<=max(DimDate[Date])))

-CumDemand = CALCULATE(SUM(Demand[DemandVal]),FILTER(ALLSELECTED(DimDate),DimDate[Date]<=max(DimDate[Date])))

-Delta(CumStock-CumDemand) = Stock[CumStock]-[CumDemand]

next step is to calculate the (MAX,MIN,JuneValue) per year of the measure Delta,but i tried several formula and i can't get it because delta is a measure not a column,even with maxx minx it didn't work, so any help please ?

to be more clear the wanted result for exp :

for the year 2019 is : MAX(9),MIN(-13),June(-12)

for the year 2020 is : MAX(40),MIN(2),June(40)

for the year 2021 is : MAX(71),MIN(38),June(55)

Drive Link to the pbix file :

https://drive.google.com/file/d/1_JdOaPobfxguf5dcy43EmEmIe8TvM2_a/view?usp=sharing

Thank you 🙂

[CNENFRNL · Accepted solution]

J'espère que c'est tout ce que tu veux.

D'allieur, les Excel Worksheet Formulas sont assez puissants.

[FZOU]

Any help please ?