How to change currency?

[sanai1505]

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_YB5gp...

[v-zhangti]

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.

[lbendlin]

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