countries
1 Topic
Need help changing currency
Hi! I need help converting my sales values between 3 difference currencies. I have 2 slicers in my dashboard, one to select the country that my store is in, and the other to select the currency that I want to view my sales figures in. I want to switch between SGD, MYR and USD. I have the conversion rate in the table below. My sales figures are reported in their base currency (Singapore Sales in SGD while Malaysia Sales in MYR). Scenarios Scenario 1: Country selected = Singapore Currency selected = SGD/MYR/USD return total sales in SGD/MYR/USD Scenario 2: Country selected = Malaysia Currency selected = SGD/MYR/USD return total sales in SGD/MYR/USD I have been experimenting with SWITCH() based on SELECTEDVALUE() of my currency slicer but I did not get it to work for all the conversions. Could anyone point me in the right direction? Thanks! Example Converting total Singapore sales from SGD to USD: 100 + 200 = SGD$300 SGD$300 / 1.349 = USD$222.39 Sample Data Currency Conversion Lookup: Conversion Rate Country Base Currency Converted Currency Conversion (notes) 1.349 Singapore SGD USD SGD to USD 4.578 Malaysia MYR USD MYR to USD Sales Table: Country Sales Singapore 100 Singapore 200 Malaysia 300 Malaysia 600Solved2.1KViews0likes1Comment