cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
yhb Frequent Visitor
Frequent Visitor

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

Dear Community,

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

1 ACCEPTED SOLUTION

Accepted Solutions
HotChilli Senior Member
Senior Member

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

Add a custom column in Power Query

#date(2019, [Month],  (([Week] -1 ) * 7 ) + [Day])
2 REPLIES 2
HotChilli Senior Member
Senior Member

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

Add a custom column in Power Query

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

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

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