Hpw to modify expression " Current month = format(today(),"mmm-yyyy") " to last month ?

[admin11]

Hi All

I have post a question on :-

https://community.powerbi.com/t5/Desktop/How-to-make-button-label-display-current-month-March-2021/m...

@amitchandak  offer me below expression work fine :-

Curr month = format(today(),"mmm-yyyy")

Now i try to modify the above expression to display last month :-

Curr month -1 = format(today()-1,"mmm-yyyy")

But it does not work. Hope some one can help me.

Paul

[jaideepnema]

Hi @admin11 ,

Change your DAX Expression as shown below:

Previous Month = FORMAT(EDATE(NOW(),-1),"MMM-YYYY")

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

[v-robertq-msft · Accepted solution]

Hi, @admin11 

According to your description and DAX formula, I think you can try this measure to get the last month using the Format() function:

Measure =

FORMAT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY())),"mmm-yyyy")

And place this measure into a card chart:

And you can get what you want.

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[admin11]

@v-robertq-msft 

Thank you very much , your approach very flexible.

Paul

[amitchandak]

@admin11 , for last month use eomonth

Curr month -1 = format(eomonth(today(),-1),"mmm-yyyy")