Dynamic Title to display previous month

[DikshantKoli]

Hi Folks, 

I am trying to get dynamic title for my card visual. It should display previous month. I used below DAX. 

abc = FORMAT(MONTH(TODAY())-1,"MMM"). 
Current Month is Aug, so result should be Jul but it give me Jan. 

[v-linhuizh-msft]

Thanks to DataNinja777  for providing a correct answer.

Hi @DikshantKoli ,

Here I will provide another method for reference:

As DataNinja777 said, formatting using "MMM" requires a complete date.

So the SWITCH function can be used to manually map the month names:

Previous Month =
SWITCH (
    MONTH ( TODAY () ) - 1,
    1, "Jan",
    2, "Feb",
    3, "Mar",
    4, "Apr",
    5, "May",
    6, "Jun",
    7, "Jul",
    8, "Aug",
    9, "Sep",
    10, "Oct",
    11, "Nov",
    12, "Dec"
)

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[DataNinja777 · Accepted solution]

Hi @DikshantKoli ,

The reason your DAX formula is returning January is that formatting using "MMM" requires a complete date, not just a month number. There are several ways to achieve your desired output, and one approach is as follows:

Previous Month = format(edate(today(),-1),"MMM")

Best regards,