Forum Discussion
Change decimal separator
Hi, I am trying to change the decimal separator of a number, without changing my windows local format, as it is for one table of my report only. Why ? : because I need to export ONE specific table ...
Did you try using Locale in the Type in Power Query?
Hi Padycosmos,
Yes I tried that, and it is not working.
I also tried by adding a column, and formating with a M formula (but it is not very clean !):
if MYCOLUMN<0 then Text.Replace(Number.ToText(MYCOLUMN*-1,"0.00"), ",", ".") else "0.00"
So, it give me the right visual and export result, but as a text, I can't avec the SUM off all the lines.
Mmmmh, forget it, I won't be able to export in a semicolon CSV file....
So after the export I would need to replace all the "," by a ";", which is not convenient at all.
So I voted to this idea https://ideas.powerbi.com/ideas/idea/?ideaid=dcdf502d-c5a8-4bf5-aef0-a9e2df596854, but with only 384 votes in 6 years, I pretty sure it will never be done 😞