Forum Discussion

Irisv's avatar
Irisv
New Member
2 years ago

Transfrom data format American to European

Hi,

 

I'm working with multiple data sources. 2 of my data files are in American formatting(##,###.##). The rest of my data is in European formatting(##.###,##). I would like to convert all my data to European, because PowerBi doesn't regonise the right decimals and I'm not able to calculate with them properly . 

 

Thanks for your help:)

Need Help

2 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    2 years ago

    can you supply some sample data, with your expected result.  

    • Irisv's avatar
      Irisv
      New Member
      2 years ago

      Yes I can 🙂 

      This is my data in American number formatting.

       

      And my other data file is like this:

      I would like to have all my numbers in the same way as the second image, so in European number format.