Forum Discussion

yugofukuda's avatar
yugofukuda
Helper IV
6 years ago
Solved

Regarding TOTALMTD

Hi,  I would like to calculate cumurative value until yesterday using todalmtd. How should I change this expression in ordar to do that?? TOTALMTD(sum(value),'Calendar'[Date])
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi yugofukuda ,

     

    Try this measure:

    _T_MTD = TOTALMTD(SUM('Table'[Value]), 'Date'[Date], 'Date'[Date] <= TODAY() - 1)

  • fhill's avatar
    fhill
    6 years ago

    Does this help?

    Date_Logic = TOTALMTD(SUM('Table'[Value]), 'Table'[Date], 'Table'[Date] < TODAY())

     

    TotalMTD has a built in FILTER Option...

     

     

camargos88's avatar
camargos88
Community Champion
6 years ago

Hi yugofukuda ,

 

Try this measure:

_T_MTD = TOTALMTD(SUM('Table'[Value]), 'Date'[Date], 'Date'[Date] <= TODAY() - 1)