Forum Discussion
Getting Alphabetic value of numeric month
Can someone tell me how to get the "mmm" value for Previous month = month(TODAY())-1. I get 5 but I need May. Thanks
"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.
WishAskedSooner
Continued Contributor
Continued Contributor"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.