Getting Alphabetic value of numeric month

[Anonymous]

Can someone tell me how to get the "mmm" value for Previous month = month(TODAY())-1.

I get 5 but I need May.

Thanks

[WishAskedSooner · Accepted solution]

"mmm" isn't actually a value in Power BI, rather it is treated as text. You can wrap your function with FORMAT(MONTH(TODAY()) - 1, "mmm"). Just be aware that this will convert the date to text which can create problems in tables, etc. when trying to order chronologically which can be overcome but is a hassle.