How to view previous month as text in a KPI card

[Rosh89]

Hi,

I would like to create a KPI card which shows the previous month as a text. For example, if it is January 2023 today then the previous month should display as 'December 2022' in the KPI card. 

I tried to use the PREVIOUSMONTH function but the KPI card shows blank. I would appreciate any tips or suggestions.

Many Thanks

Best Regards 

Roshan

[Rosh89]

Hi @PaulOlding Many thanks! it worked.

[PaulOlding · Accepted solution]

Hi @Rosh89 

A measure like this should get that for you:

Last Month = FORMAT(EOMONTH(TODAY(), -1), "mmmm yyyy")