Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

24:00:00 Records Changing Type to Duration

Hi guys, how is everything?   I’ve a power query table with many columns that got type of “any” at the beginning, many of these columns got records of 24:00:00, when I change the type of the mentio...
Need Help
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
4 years ago

= Duration.From(List.Sum(List.Transform(List.Zip({List.LastN(Text.SplitAny("0."&"24:00:00",".:"),4),{1,1/24,1/1440,1/86400}}),each Number.From(_{0})*_{1})))