Total MTD calculation

[Anonymous]

Hi Team,

Could you please help me to calculate totalMTD. please see below sample example.

We have data from Jan 1st to Jan 4th, Total MTD is 17, Need to display 17 from Jan 1st  to Jan 4th similar for Feb.

I am trying to use TOTALMTD function, but couldn't get the result.  Please provide some inputs.

Thank you in advance.

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

this month = CALCULATE(SUM(Table[Value]),DATESMTD(ENDOFMONTH('Date'[Date])))

Make sure you use date table