Convert month name abbreviation to full date

[Anonymous]

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 month	Fuel wasted	Fuel usage
Jan	582.82	4786.53
Feb	466.9	3962.21
Mar	544.18	3715.88
Apr	502.32	7239.526
Maj	563.5	5180.98
Jun	1101.24	5306.56
Jul	756.7	6095.46
Aug	895.16	5799.22
Sep	0	0
Okt	0	0
Nov	0	0
Dec	0	0
Total	5412.82	42086.366

[wdx223_Daniel · Accepted solution]