Forum Discussion

sanai1505's avatar
sanai1505
Regular Visitor
4 years ago

How to change currency?

Hi Everyone,

 

I'm new to Power BI and I'm having some trouble with changing the currency. Some of my data is in USD and some in CAD, I need to convert all my data into USD.

 

This file is similar to the data that I'm working with. I'm trying to have all the rental costs in USD. 

 

https://mytechnology-my.sharepoint.com/:x:/g/personal/sanai_myb-site_com/EYsFGUBL1hhDoBaCJBtUH_YB5gpleqX0L9ap0dx6WaC0Zg?e=uspqZT

Need Help
Tips and Tricks

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Needs more details. Where do you source your exchange rates from? Are they monthly?  Does your data have a date column?

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, sanai1505 

     

    The link you shared is no longer valid. Can you provide some of the example data? What do you expect the output to look like and can you show it with a picture?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.