Forum Discussion

anoomohan's avatar
anoomohan
Icon for Helper III rankHelper III
3 years ago
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...
Need Help
  • DataNinja777's avatar
    DataNinja777
    3 years ago

    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

     

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
3 years ago

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