Forum Discussion

_JHFischer's avatar
_JHFischer
Advocate I
6 years ago
Solved

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

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

Need Help
  • AlB's avatar
    AlB
    6 years ago

    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 

1 Reply

  • AlB's avatar
    AlB
    Community Champion
    6 years ago

    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