Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Format Month-Year from Date Hierarchy

I have a date hierarchy field, but the values show up in my visual like this.

What is the DAX formula to make it so my field value shows up like this: "January, 2023".

Thanks!

Need Help
  • ThxAlot's avatar
    ThxAlot
    3 years ago

    Uncheck the auto date/time option and add an calculated column manually.

    Month-Year = FORMAT( SubEndMonth[Date], "MMM,yyyy" )

     

     

4 Replies

  • ThxAlot's avatar
    ThxAlot
    Icon for Super User rankSuper User
    3 years ago

    Uncheck the auto date/time option and add an calculated column manually.

    Month-Year = FORMAT( SubEndMonth[Date], "MMM,yyyy" )

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Oh wow! I didn't even need the calculated column. As soon as I unchecked the Date/Time option, it just magically became the month year format I wanted! THANK YOU SO MUCH !!!