Which DAX function can use in real time projects TOTALMTD or DATESMTD

[sudhav]

Hai my dear professionals, in real time projects or real time working , which dax function we can use to calculate cummulative/running total of Month, DatesMTD or TotalMTD

Please repl me 

TIA

[amitchandak]

@sudhav , You need to create date table 

For monthly cumulative

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

Quarterly cumulative 

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))

yearly

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))

Overall

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

[sudhav]

ya sir i know the formulae, but i am asking that which dax function we can use, total mtd or datesmtd

could you please tell me

[amitchandak · Accepted solution]

@sudhav , both do the same Job.

datesmtd can be used with calculate.

totalmtd can be used without calculate, you have option to give on filter condition. More than that you need to use calculate

I usually use datesmtd

refer for more

https://www.reddit.com/r/PowerBI/comments/rr8l0u/totalmtd_vs_calculate_datesmtd_in_dax/

[sudhav]

wow, really great video , thankyou so much sir