Powre Query, Create date based on three other columns in table

[_JHFischer]

Hi

I want to create a Date column based on three existing columns in the same table, like below

Year | Month | Day | Date (to be created)

2020 | 01       | 05   | 05-01-2020       

what is the M-code formula her 🙂

Thanks

[AlB · Accepted solution]

Hi @_JHFischer 

you can just add a custom column with:

#date([Year], [Month], [Day])

 Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs

Cheers