How to display last month along with year ?

[Anonymous]

I wanted to display the last month with year in a card visual.

Suppose now it's Dec 2022, then it should display Nov 2022. If it's Jan 2023, it should display Dec 2022.

The format should be either "MMM YYYY" or full month name year. 

[FreemanZ]

hi @Anonymous 

try to plot with a column like this:

MMMYYYY = FORMAT(EDATE(TODAY(), -1), "MMM YYYYY")

[Mikelytics · Accepted solution]

Hi @Anonymous 

Last Month = FORMAT(EOMONTH(TODAY(),-1), "MMMM /YYYY")

If you work with a data table and you want to filter you can also do something like:

Last Month = FORMAT(MAX(DimDate[Date]),-1), "MMMM /YYYY")

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

[Uspace87]

@Anonymous 

Last Month = FORMAT(TODAY() - 1, "MMMM /YYYY")

[Uspace87]

@Anonymous 

sorry, try this:

Last Month =

FORMAT(

    EOMONTH(TODAY(), -1),

    "MMMM /YYYY"

)