Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
_JHFischer
Advocate I
Advocate I

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

1 ACCEPTED SOLUTION
AlB
Super User
Super User

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 

SU18_powerbi_badge

View solution in original post

1 REPLY 1
AlB
Super User
Super User

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 

SU18_powerbi_badge

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors