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 n...
  • parry2k's avatar
    6 years ago

    o59393 add custom column with this expression in Power Query

     

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

    Would appreciate Kudos 🙂 if my solution helped.