Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Convert month name abbreviation to full date

Hello,

I have the following table in Power Query and i am trying to use it in a table visualization and also connect it to my Calendar table to sort by month and year. However, the month names are just abbreviations from the source file - is it possible to fix it to show as the full date? The Target month column should be: 31 January 2022, 28 February 2022, etc. Any help is much appreciated!

 

Target monthFuel wastedFuel usage
Jan582.824786.53
Feb466.93962.21
Mar544.183715.88
Apr502.327239.526
Maj563.55180.98
Jun1101.245306.56
Jul756.76095.46
Aug895.165799.22
Sep00
Okt00
Nov00
Dec00
Total5412.8242086.366