Forum Discussion
bourne2000
Helper V
Helper VConvert the column into duration - Throwing an error
Hi I have the below column I am trying to convert it into duration. Getting below error message Expression.Error: We couldn't parse the Duration literal. Details: 24:18:34 I c...
AllisonKennedy
Community Champion
Community Champion
If you're going to use the Custom #duration( ) function then no need for the if else:
try
let _arr = List.Transform(Text.Split([Duration],":"),each Number.FromText(_)) in
#duration (
0 , _arr{0} , _arr{1} , _arr{2}
)
otherwise null
TheoCCommunity Champion
Community ChampionThat's a good pick up AllisonKennedy