Forum Discussion
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])
Hi yugofukuda ,
Try this measure:
_T_MTD = TOTALMTD(SUM('Table'[Value]), 'Date'[Date], 'Date'[Date] <= TODAY() - 1)
Does this help?
Date_Logic = TOTALMTD(SUM('Table'[Value]), 'Table'[Date], 'Table'[Date] < TODAY())TotalMTD has a built in FILTER Option...
3 Replies
Hi yugofukuda ,
Try this measure:
_T_MTD = TOTALMTD(SUM('Table'[Value]), 'Date'[Date], 'Date'[Date] <= TODAY() - 1)
camargos88 fhill
Thank you very much!!!!
Does this help?
Date_Logic = TOTALMTD(SUM('Table'[Value]), 'Table'[Date], 'Table'[Date] < TODAY())TotalMTD has a built in FILTER Option...
