Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How do I convert from a ##.###,## number format to a ##,###.## number format?
There is no room to edit the data before it comes into Power Query, so needs to be changed within the query.
Current format is set to text as it cannot read the current character format as Decimals.
Thanks!
Solved! Go to Solution.
The solution was to replace the dots with x's.
Then replace the commas with dots.
Then replace the x's with commas.
The solution was to replace the dots with x's.
Then replace the commas with dots.
Then replace the x's with commas.
Hello @Anonymous ,
you can apply a Table.TransformColumns like this
Table.TransformColumns(Quelle, {{"decimals", each Number.From(_, "de-de")}})
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
Hi @Anonymous
You can replace values like below.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQzN7TQszQ30TExVIqNBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Replaced Value" = Table.ReplaceValue(#"Changed Type",".","#",Replacer.ReplaceText,{"Column1"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",",",".",Replacer.ReplaceText,{"Column1"}),
#"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","#",",",Replacer.ReplaceText,{"Column1"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Replaced Value2",{{"Column1", type number}})
in
#"Changed Type1"
Where would I slot that into the existing code?
Hello @Anonymous ,
somewhere in between.. meaning createing a empty line, create a new variable like Transform =,
past my code and connect it to the steps and after
BR
Jimmy