topic Re: Dynamic name of measure for MTD calculations,Pre Month MTD name,Last to last month name in DAX Commands and Tips

Dynamic name of measure for MTD calculations,Pre Month MTD name,Last to last month name

Anonymous — Fri, 06 Aug 2021 10:28:59 GMT

Hello Guys,

I have calculated MTD,Last month MTD, Last to last month MTD etc but problems are here is how to assing the dynamic name of the calculations like,

for example

this is current month Aug21 so MTD should be MTD Aug'21 and if we are in next month then it should automatically MTD Sep'21 on headers.

Similarly I have to show the name of Last month calculations, last to last months etc.

Any suggestions please help me.

Thanks.

Tanushree_Kapse — Fri, 06 Aug 2021 13:17:55 GMT

Hi Anonymous ,

Please find the below measures to display the month names:

Current date = FORMAT(CALCULATE(max('Table (3)'[Date]),DATESMTD('Table (3)'[Date])),"MMM-YY")

Last Month = FORMAT(CALCULATE(max('Table (3)'[Date]),DATESMTD(dateadd('Table (3)'[Date],-1,MONTH))),"MMM-YY")

Last to Last Month = FORMAT(CALCULATE(max('Table (3)'[Date]),DATESMTD(dateadd('Table (3)'[Date],-2,MONTH))),"MMM-YY")

I hope this helps!

Mark this as a solution if I answered your question. Kudos are always appreciated.

Thanks!!