Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Format Month-Year from Date Hierarchy

‎07-07-2023 12:55 PM

date hierarchy.jpg

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!

date visual.jpg

Labels:
Message 1 of 5
491 Views
0
1 ACCEPTED SOLUTION
ThxAlot
Super User
Super User

‎07-07-2023 01:07 PM
Syndicated - Outbound

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

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

 

ThxAlot_0-1688760256138.png

 



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday)


)



View solution in original post

Message 2 of 5
488 Views
0
4 REPLIES 4
ThxAlot
Super User
Super User

‎07-07-2023 01:07 PM
Syndicated - Outbound

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

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

 

ThxAlot_0-1688760256138.png

 



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday)


)



Message 2 of 5
489 Views
0
avatar user
Anonymous
Not applicable
In response to ThxAlot

‎07-07-2023 01:15 PM
Syndicated - Outbound

p.s. THANKS ALOT @ThxAlot

Message 5 of 5
477 Views
0
avatar user
Anonymous
Not applicable
In response to ThxAlot

‎07-07-2023 01:15 PM
Syndicated - Outbound

p.s. THANKS ALOT @ThxAlot

Message 4 of 5
478 Views
0
avatar user
Anonymous
Not applicable
In response to ThxAlot

‎07-07-2023 01:14 PM
Syndicated - Outbound

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 !!!

date month.jpg

Message 3 of 5
478 Views
0
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Stop
View All
Recommendations
Top Solution Authors (Last Month)
View All
Top Kudoed Authors (Last Month)
View All