Daily value

[IF]

Hi,

I want to show the daily value in a table/matrix. I have the following sample:

DateValueReadyStorage

MatNo	Date	Value	Ready	Storage
A1	7/1/2022	2	null	null
A1	7/2/2022	3	null	null
A1	7/2/2022	4	null	null
A1	7/3/2022	4	null	null
A1	7/4/2022	3	null	null
A1	null	null	8	20
A3	null	null	4	6
A3	7/1/2022	2	null	null
A3	7/2/2022	5	null	null
A3	7/3/2022	2	null	null
A3	7/4/2022	3	null	null
A3	7/5/2022	2	null	null
A3	7/5/2022	5	null	null

The column is Ready+Storage. I want to show the daily values after calculating the daily value. The calculation should be what is left by column value - value for the day. For example; A1 is having value 2 on 1 July. The "left" should be 28-2=26. The next day's value is 7 and the "left" value for July 2 should be 26-7 =19 and so on.

Thanks in advance!

[v-henryk-mstf]

Hi @IF ,

Whether the advice given by @MFelix  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[MFelix · Accepted solution]

Hi @IF ,

Try to add the following measure:

Measure = CALCULATE( sum('Table'[Storage]) + SUM('Table'[Ready]), ALLSELECTED('Table'[Date])) - CALCULATE(SUM('Table'[Value]),'Table'[Date] <= MAX('Table'[Date]))

[IF]

Thanks. It works.