Forum Discussion
Anonymous
3 years agoNot applicable
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 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 |
1 Reply
- wdx223_Daniel
Community Champion