Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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
Need Help
  • WishAskedSooner's avatar
    WishAskedSooner
    2 years ago

    "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.

1 Reply

  • WishAskedSooner's avatar
    WishAskedSooner
    Icon for Continued Contributor rankContinued Contributor
    2 years ago

    "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.