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

[Anonymous]

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.

@Tanushree_Kapse 

Thanks.

[Tanushree_Kapse · Accepted solution]

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!!