Forum Discussion
Solved
Can steps be eliminated?
I have created the following steps in Power Query for one column but need to replicate these steps on 4 additional columns. Is there a way to combine any of these steps? This is a duration value(in...
replace all of those steps in one as this
NewStep=Table.TransformColumns(#"Renamed Columns",{"InstallTimeEa",each List.Sum(List.Transform(List.Zip({Text.Split(_,":"),{1,60,3600}}),each Number.From(_{0})/_{1}))})
This was an awesome solution to this issue. Thank you sir!