Forum Discussion
Solved
Dynamic Datatype from Text to Number conversion is different Localization per Row
Hello there,i have a power query which is updating excel files placed within a specific folder. The layout of these files is always identical - therefor i can easily set the appropriate steps neeed ...
assume all the values in this column is integer, then try this code
NewStep=Table.TransformColumns(PreviousStepName,{"Quantity",each let a=Text.SplitAny(_,".,") in Number.From(Text.Combine(a))/(if Text.Length(List.Last(a))=2 then 100 else 1)})
assume all the values in this column is integer, then try this code
NewStep=Table.TransformColumns(PreviousStepName,{"Quantity",each let a=Text.SplitAny(_,".,") in Number.From(Text.Combine(a))/(if Text.Length(List.Last(a))=2 then 100 else 1)})