Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Dynamic Title to display previous month

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...
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    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,

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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!