Forum Discussion
Solved
Date format wrong in excel source
hi, My excel source has multiple columns with 3 columns for date - YEAR, MONTH NAME, DAY NUMBER - but issue is all these 3 columns are formatted in text (year and month) and day number in numeri...
Hi anoomohan
I am also not that familiar with M language, but the good thing about Power Query is that you can just click ribbons to achive the tasks which are not that complicated. For this task, I just clicked the ribbons mostly to produce the required output.
I attach the pbix file in the link below for this task in which you can see the applied steps.
https://1drv.ms/u/s!AlqFfzVTqicpnWvUaoX8e76td6aH?e=KUiM3V
It works, thank you