Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
bdehning
Post Prodigy
Post Prodigy

Month Column in Power Query and Need to Shorten and Combine with Year

I have a column for Month with full month spelled out and one column for Year.  

 

How do I create a column with 3 letter Months so that I can create a merged columns of 3 letter month and the year?

1 ACCEPTED SOLUTION
ChrisMendoza
Resident Rockstar
Resident Rockstar

@bdehning - you can do as:

image.png

Add custom column:

Text.Combine( { Text.Start ( [MonthName], 3 ), Text.From( [YearNum] ) }, " " )





Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
aj1973
Community Champion
Community Champion

Hi @bdehning 

Use LEFT

aj1973_0-1668815877102.png

Then CANCATENATE

aj1973_1-1668815918579.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

ChrisMendoza
Resident Rockstar
Resident Rockstar

@bdehning - you can do as:

image.png

Add custom column:

Text.Combine( { Text.Start ( [MonthName], 3 ), Text.From( [YearNum] ) }, " " )





Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.