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!
1 ACCEPTED SOLUTION
Uncheck the auto date/time option and add an calculated column manually.
Month-Year = FORMAT( SubEndMonth[Date], "MMM,yyyy" )
Uncheck the auto date/time option and add an calculated column manually.
Month-Year = FORMAT( SubEndMonth[Date], "MMM,yyyy" )
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 !!!
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
