Power Query: Abbreviate Month / Day Name

Question

Good dayI 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

sergeibaklan · Answer

HiltonT&nbsp;
You may wrap in formula bar the formula like
each Text.Start(Date.MonthName(_),3)
and vote for the short name idea here&nbsp;Add short month name and short day name in Power Query&nbsp;

Forum Discussion

Power Query: Abbreviate Month / Day Name

1 Reply

Resources