Forum Discussion
Total MTD calculation
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.
Anonymous , Try a measure like
this month = CALCULATE(SUM(Table[Value]),DATESMTD(ENDOFMONTH('Date'[Date])))
Make sure you use date table
1 Reply
Anonymous , Try a measure like
this month = CALCULATE(SUM(Table[Value]),DATESMTD(ENDOFMONTH('Date'[Date])))
Make sure you use date table