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

[bdehning]

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?

[aj1973]

Hi @bdehning 

Use LEFT

Then CANCATENATE

[ChrisMendoza · Accepted solution]

@bdehning - you can do as:

Add custom column:

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