Forum Discussion
Multiple Region Number formats in a Single Column
Hello, I have a file that runs a macro, and then downloads some SAP records. Then a query retrieves this data, but the thing is that when it brings the data, depending on the user's region, it cou...
NewStep=Table.TransformColumns(PreviousStepName,{"ColumnName",each let a=Text.SplitAny(Text.From(_),",.") in Number.From(Text.Combine(List.ReplaceRange(a,List.Count(a)-1,0,{"."})),"en-US")})
Thanks a lot, we were struggling a lot with this issue, you saved us!