Forum Discussion
Solved
Split multiple columns in one step
Hello, I have two date and time colums that I am needing to split by delimiter and I want to split all two of these columns into one step instead of having to do it in individual steps. I tried a cou...
Hi romoguy15 ,
If your columns are already of the type datetime, then you could use this statement:
= Table.TransformColumns(#"Changed Type",{{"Work Order Date Created", DateTime.Date, type date}, {"Work Order Date Completed", DateTime.Date, type date}})In advanced editor it would look like this:
#"Extracted Date" = Table.TransformColumns(#"Changed Type",{{"Start date time", DateTime.Date, type date}, {"End date time", DateTime.Date, type date}}),Let me know if this helps!
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
if this is not what you are looking for, explain the waiting table in detail with examples
Hi romoguy15 ,
If your columns are already of the type datetime, then you could use this statement:
= Table.TransformColumns(#"Changed Type",{{"Work Order Date Created", DateTime.Date, type date}, {"Work Order Date Completed", DateTime.Date, type date}})
In advanced editor it would look like this:
#"Extracted Date" = Table.TransformColumns(#"Changed Type",{{"Start date time", DateTime.Date, type date}, {"End date time", DateTime.Date, type date}}),
Let me know if this helps!
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Well this method worked alot smoother than I was trying. Thank you