Power Query: Abbreviate Month / Day Name

Copper Contributor

Good day
I am looking for a solution for the following:
Using power query I have created additional columns from a date field in the source table. Is it possible to shorten the Month name for eg January = Jan and Day name eg. Monday = Mon ?

Thank you in advance if anyone can offer a solution. Regards Hilton

1 Reply

@HiltonT 

You may wrap in formula bar the formula like

each Text.Start(Date.MonthName(_),3)

and vote for the short name idea here Add short month name and short day name in Power Query