Forum Discussion

IF's avatar
IF
Post Prodigy
4 years ago
Solved

Daily value

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 nu...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    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]))

     

     

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

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