May 14 2020 09:44 AM
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 different month. But i'm just looking for a function that sums spending in this month and that updated as the calendar evolves.
There are any function for that?
May 14 2020 12:53 PM
You could add an extra column (maybe hide it if you want) where you show the month by using MONTH(Date).
You can them use SUMIFS and check the MONTH column.
Another possibility - depending on your data it may be easier to use a pivot table?
Hope this helps.
Peter
May 14 2020 12:55 PM
May 15 2020 03:01 AM
May 15 2020 01:12 PM
It shall work
ValueMTD:=CALCULATE(SUM(Table1[Value]),DATESMTD('Calendar'[Date]))
if you have correct relationship with Calendar