Question on Currency Types

[Anonymous]

Good morning all! Quick question on something. I am creating a financial dashboard, encompassing how areas of a college and satellite campuses are budgeting their money. I also have a slicer on the dashboard for users to drill down between the name of the location they are a part of. All of the campuses are a part of the USA, and there are a few which are based in Canada. Is there a way to bring in the numbers for USD Generically, and then convert ones which are based in Canada as the Canadian Currency? I'm not sure if this would be a DAX Formula or not.

[amitchandak · Accepted solution]

@Anonymous , Usually, I bring in base current and Global currency measure and switch them

There are few examples

https://businessintelligist.com/2015/03/17/power-bi-tutorial-how-to-implement-currency-conversion-using-power-query-and-power-pivot/
https://blog.beyondimpactllc.com/blog/building-a-dynamic-currency-converter-with-power-bi


https://www.youtube.com/watch?v=9oPFgHvGyKc
https://blog.enterprisedna.co/how-to-download-latest-exchange-rates-into-your-power-bi-model/
https://radacad.com/currency-converter-power-bi-function-part-1
https://radacad.com/currency-exchange-rate-conversion-in-power-bi-with-live-rates-part-2

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.