Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Please, in your answer, don't mention "thousand separator" or "regional settings".
How can I replace dot in all decimal numbers to comma as a mass replacement in a column? The column is already "decimal number" type but some of the numbers come with dot from the SQL and the column doesn't recognize them as numbers and they are then "text". This produces errors.
Thanks in advance.
Solved! Go to Solution.
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.
Hi @Finnair ,
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?
@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 ","
Proud to be a Super User!
Paul on Linkedin.
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.
You can achieve this in Power Query using the "Replace values" function under the "Home" tab
Proud to be a Super User!
Paul on Linkedin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |