Create a Visual that Displays Prior Month Name

[Anonymous]

I would like to display the previous month in some sort of visual so I can create appropriate YTD - "Month" titles on my dashboards.  My data is refreshed every month, so the prior month would work best in this situation.  

I started using this simple formulain a measure, but it returns a number and not a month name.

Previous Month = month(today())-1

Anybody have a good solution to show month name? Thanks!

[MDrabik]

Here's something that's worked for me in the past, and it accounts for the January back to December issue I have when subtracting 1 from the month number:

Previous Month = FORMAT ( EOMONTH( TODAY (), -1 ), "MMM-YYYY" )

You can easily change the format of the output as needed.

Thanks!

Matt Drabik

[amitchandak · Accepted solution]

Try like

Previous Month = format(date(year(today()), month(today())-1,1),"MMM-YYYY")

You can change format as per need