Log In
Register
Home
Active Member
October 23, 2020
Offline
Hi all,
kindly I am facing a problem once I use a custom column - power query - for the #date equation
Note: my Excel is 2019
I attached a file excel you can check it
Thank You In Advance
See Answer
October 5, 2010
Offline
Hi Ammar,
I presume that you are using dd/mm/yyyy?
After splitting the text into 3 columns, recombine it with / as the separator. You can then convert it using locale to a date.
See attached file for the query/steps.
Regards
Phil
Answers Post
Active Member
October 23, 2020
Offline
Hi Philip
Thank You for the clarification
but actually, I'm looking to solve the error if I co with -power query ---> add column ---->custom column
same in the excel and photo
I would like to know why I got Error?
October 5, 2010
Offline
Hi Ammar,
The order of the parameters for #date are year, month, day.
You've got day, month, year.
https://docs.microsoft.com/en-...../sharpdate
This is the correct format
= Table.AddColumn(#"Changed Type1", "Custom", each #date([Test.3],[Test.2],[Test.1]))
Regards
Phil
1 Guest(s)
