Forum Discussion

TimmK's avatar
TimmK
Icon for Helper IV rankHelper IV
4 years ago
Solved

Remove Months from Cumulative Total

I use the following measure to get my cumulative total: Measure = CALCULATE([Cash],FILTER(ALL('Date'),'Date'[Date]<=MAX('Date'[Date])))   It generally works fine. However, in the visual months are...
  • tamerj1's avatar
    tamerj1
    4 years ago

    TimmK 
    Then try

     

    Measur =
IF (
    MIN ( 'Date'[Date] ) <= TODAY (),
    CALCULATE ( [Cash], 'Date'[Date] <= MAX ( 'Date'[Date] ), ALL ( 'Date' ) )
)

    *Edited

    Changed MAX to MIN in the IF statement

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

TimmK 
Then try

 

Measur =
IF (
    MIN ( 'Date'[Date] ) <= TODAY (),
    CALCULATE ( [Cash], 'Date'[Date] <= MAX ( 'Date'[Date] ), ALL ( 'Date' ) )
)

*Edited

Changed MAX to MIN in the IF statement

 

TimmK's avatar
TimmK
Icon for Helper IV rankHelper IV
4 years ago

Thank you very much. 🙂

 

It works with MAX.

 

I adapted the solution a bit and now it works as it should:

IF(
   MAX( 'Date'[YM] ) > FORMAT( TODAY(), "YYYYMM" ),
   BLANK(),
   CALCULATE([Cash], FILTER( ALL( 'Date' ), 'Date'[Date] <= MAX( 'Date'[Date] ) )
))