TOTAL of the month (just)

Copper Contributor

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?

5 Replies

@carlos1945 

 

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

The best thing to do is to use PivotTable for your dataset
Yes i know some ways to reach the goal, using IF measures. But i thought there might be some function DAX more direct to get the goal.

But It's ok. Thanks for your help

@carlos1945 

It shall work

ValueMTD:=CALCULATE(SUM(Table1[Value]),DATESMTD('Calendar'[Date]))

if you have correct relationship with Calendar

Thank you very mutch