Notifications
Clear all
Power Query
3
Posts
3
Users
0
Reactions
1,176
Views
Topic starter
Hi, in the file I attached in Sheet2, the DATE2 column is not standard and it is not possible
to convert the column to a date, therefore I separated it into 3 Day Month Year columns.
The question is how do you create a date value that connects the 3 columns
(like the Date function in Excel)
Thank you very much for the answer!!!!!!! Leah
Posted : 06/02/2023 4:28 am
Your file didn't come through, but assuming the three columns are numbers like 5, 2 and 2023 then you can add a custom column with the following function.
= #date([Year],[Month],[Day])
Posted : 06/02/2023 5:47 am
While Riny has provided a formula solution, you could also achieve similar results by combining (concatenating) the columns with a delimiter such as the "/"
Posted : 06/02/2023 6:59 pm
