Creating Date Column out of Text Columns Date Number, Week Number Month Number

[yhb]

Dear Community,

Please help me create a date column out of 3 text columns: Date Number, Week Number Month Number. Thank you!date format needed

[HotChilli · Accepted solution]

Add a custom column in Power Query

#date(2019, [Month],  (([Week] -1 ) * 7 ) + [Day])

[yhb]

Dear @HotChilli , thank you! Appreciate your help! You rock my world!