Forum Discussion
How to replace dot in decimal numbers to comma (not thousand separator!)
Hi Anonymous ,
You may get the result you want by using the "substitute" function.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Anonymous ,
If you are using the "directquery" connection mode, you could only modify the data at the data source.
If you are using the "import" connection mode, you could modify the data in edit queries.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
V-lianl-msft with replace values we can replace only numbers not (.) any other alternative?
PaulDBrownCommunity Champion
Anonymous
You can use "Replace Values" in Power Query to change any character (or strings, spaces...), even into "blank" to remove it if you so wish (leave the "Replace with" box empty to remove the character). Just make sure the column is formatted as text.
Here is an example changing from " . " to ","
- V-lianl-msft
Hi Anonymous ,
You may get the result you want by using the "substitute" function.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.V-lianl-msftThank you