Can anyone help me formatting the millions?

ACol123 · ‎10-30-2023

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 · ‎10-30-2023

Refer to this solution

Ahmedx · ‎10-30-2023

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 · ‎10-30-2023

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 · ‎10-30-2023

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?

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Uzi2019 · ‎10-30-2023

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

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Helpful resources