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

     

     

MFelix's avatar
MFelix
Super User
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]))

 

 

IF's avatar
IF
Post Prodigy
4 years ago

Thanks. It works.