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!
  • ThxAlot's avatar
    3 years ago

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

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