Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Transform month name and year into date format

Hi all

 

How can I add and transform 2 columns from power query that contains the month name and year into mm/dd/yyyy format.

 

 

So for the first example where it says 2019 January, the new column should be 1/1/2019.

 

Thanks!

  • o59393 add custom column with this expression in Power Query

     

    Date.FromText(Number.ToText([Year]) & "-" & [Month] & "-01")

    Would appreciate Kudos 🙂 if my solution helped.

     

2 Replies

  • o59393 add custom column with this expression in Power Query

     

    Date.FromText(Number.ToText([Year]) & "-" & [Month] & "-01")

    Would appreciate Kudos 🙂 if my solution helped.