https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-Date-Column-out-of-Text-Columns-Date-Number-Week-Number/m-p/738192#M2153 <P>Add a custom column in Power Query</P><PRE>#date(2019, [Month], (([Week] -1 ) * 7 ) + [Day])</PRE> Thu, 11 Jul 2019 23:50:44 GMT HotChilli 2019-07-11T23:50:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-Date-Column-out-of-Text-Columns-Date-Number-Week-Number/m-p/738037#M2151 <P>Dear Community,</P><P>Please help me create a date column out of 3 text columns: Date Number, Week Number Month Number. Thank you!<img /></P> Thu, 11 Jul 2019 19:35:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-Date-Column-out-of-Text-Columns-Date-Number-Week-Number/m-p/738037#M2151 yhb 2019-07-11T19:35:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-Date-Column-out-of-Text-Columns-Date-Number-Week-Number/m-p/738192#M2153 <P>Add a custom column in Power Query</P><PRE>#date(2019, [Month], (([Week] -1 ) * 7 ) + [Day])</PRE> Thu, 11 Jul 2019 23:50:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-Date-Column-out-of-Text-Columns-Date-Number-Week-Number/m-p/738192#M2153 HotChilli 2019-07-11T23:50:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-Date-Column-out-of-Text-Columns-Date-Number-Week-Number/m-p/738742#M2173 <P>Dear&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="81111" data-lia-user-login="HotChilli" class="lia-mention lia-mention-user">HotChilli</a> , thank you! Appreciate your help! You rock my world!</P> Fri, 12 Jul 2019 12:37:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-Date-Column-out-of-Text-Columns-Date-Number-Week-Number/m-p/738742#M2173 yhb 2019-07-12T12:37:02Z