Can anyone help me formatting the millions?

[ACol123]

Hi everyone.

I imported a csv into my Power BI project. The data present in the csv has the "." as a separator. and not the comma.

How can I replace the dot with a comma? For example I would need 336.63M to be 336.63

[Ahmedx]

Refer to this solution

https://community.fabric.microsoft.com/t5/Desktop/change-format-by-using-dot-instead-of-comma/m-p/37...

[Ahmedx]

try this

m1 = FORMAT([Measure],"#,,.0M","fr-fr") // replace the dot with a comma
OR
m2 = FORMAT([Measure],"#,,.0M","us-EN") // replace the comma with a dot

[ACol123]

I entered the formula: FORMAT/[Measure];"#.00";"us-EN")

but FORMAT transforms the measurement into text, it doesn't help me with the graphs.

[Ritaf1983]

Hi @ACol123 
Do the numbers on CSV convert to millions format?

I didn't understand the example that you gave...
can you share please a few rows of data?

[Uzi2019]

Hi @ACol123 
You can use Subsitute function like below for replace . with ,
Total  = SUBSTITUTE(MIN([amount],".",",")

If this not what you are ex

pecting then provide the input data and expected out in excel form.

If my post helps please give kudos and accept it as a solution!
thanks