Forum Discussion

IF's avatar
IF
Icon for Post Prodigy rankPost 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

MatNoDateValueReadyStorage
A17/1/20222nullnull
A17/2/20223nullnull
A17/2/20224nullnull
A17/3/20224nullnull
A17/4/20223nullnull
A1nullnull820
A3nullnull46
A37/1/20222nullnull
A37/2/20225nullnull
A37/3/20222nullnull
A37/4/20223nullnull
A37/5/20222nullnull
A37/5/20225null

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!

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

     

     

3 Replies

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

     

     

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity 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