topic Re: Dynamic Title to display previous month in DAX Commands and Tips

Dynamic Title to display previous month

Anonymous — Sat, 31 Aug 2024 08:21:23 GMT

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.

Re: Dynamic Title to display previous month

DataNinja777 — Sat, 31 Aug 2024 08:56:04 GMT

Hi Anonymous ,

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,

Re: Dynamic Title to display previous month

Anonymous — Mon, 02 Sep 2024 06:26:23 GMT

Thanks to DataNinja777 for providing a correct answer.

Hi Anonymous ,

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!