Forum Discussion
TOTAL of the month (just)
Hi Community, I need to have the all of the spending corresponding for the current month. I have tried TOTALMTD and DATESMTD but in the last case it added until last row, even if it's in the differe...
It shall work
ValueMTD:=CALCULATE(SUM(Table1[Value]),DATESMTD('Calendar'[Date]))if you have correct relationship with Calendar
- Thank you very mutch
