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 of the report into a CSV format to import it in my ERP, all the other tables and graphs should keep my standard format.
Standard format : # ##0,00 (example : 1234,33) > it's a comma, used in 99% of my reports.
For this specific table, I need this format 1234.33 (with a dot), so I will be able to export its content to a csv file.
I tried to change in Power Query (using US decimal format), not working
If in PowerQuery I use the Replace Value of a column formated in text, I can do partially what I want, with to situation that are not good for me : I wont have 2 decimals for numbers like 1234,00 (and I need thoose 2 decimals), and PB won't be able to do some calculation (no more sum for example)
I can't find a way to do it.
Thanks for your help