Forum Discussion
Anonymous
3 years agoNot applicable
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!
- 3 years ago
Uncheck the auto date/time option and add an calculated column manually.
Month-Year = FORMAT( SubEndMonth[Date], "MMM,yyyy" )