Forum Discussion
Failed Text to Value Convenrsion
Hello everyone, could someone check the below file and advise how could I deal with these entries in the power query? It is read there with the data type of any, but apparently they're text, I cannot...
Table.AddColumn(Table1_Table, "toduration", each let d=Text.Split([Duration],":") in #duration(0,Number.FromText(d{0}),Number.FromText(d{1}),Number.FromText(d{2})))
Table.AddColumn(Table1_Table, "toduration", each let d=Text.Split([Duration],":") in #duration(0,Number.FromText(d{0}),Number.FromText(d{1}),Number.FromText(d{2})))