Forum Discussion
o59393
Post Prodigy
6 years agoTransform 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.