Aug 14 2020 03:07 AM
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
Aug 14 2020 03:19 AM
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