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 be Jul but it give me Jan. 

 

  • 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,

2 Replies

  • DataNinja777's avatar
    DataNinja777
    Icon for Super User rankSuper User
    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!