Forum Discussion
Fixed Currency conversion change with filters
Currently, my data is in their local currency
i would need assistance on how to convert the currency respectively by just clicking the filter as shown below :
I have a fixed currency exchange rate in this table :
Sample data of the sales :
You may download the sample data here
Hi Nahid_3152
My revenue is in different currency like SGD/IDR/MYR so i can't use this measures :
Currentsales = IF(ISFILTERED('Currency'[CurrencyName]),SUM(Sheet1[Value])*SUM('Currency'[Rate]),SUM(Sheet1[Value])
)This is my currency table :
Which has "conversionRate"
This is the revenue data:Example 1 : Store 6, the revenue is 68,487,038 IDR and it should be 4,775.8574 USD
Example 2: Store 4 has 15,392.57 MYR revenue. It should be 3,678.466 USD
Maybe you can take a look at the sample :Example 2.pbix (dropbox.com)
Thank you
6 Replies
- Nahid_3152
Helper I
Hi,
Create a currency table. Then create a measure using
Currentsales = IF(Currency TableData model1st Mesure2nd MesureISFILTERED('Currency'[CurrencyName]),SUM(Sheet1[Value])*SUM('Currency'[Rate]),SUM(Sheet1[Value]))Hi Nahid_3152
My revenue is in different currency like SGD/IDR/MYR so i can't use this measures :
Currentsales = IF(ISFILTERED('Currency'[CurrencyName]),SUM(Sheet1[Value])*SUM('Currency'[Rate]),SUM(Sheet1[Value])
)
- Nahid_3152
Hi,
Can you insert your currency value in the currency table?
This is my currency table :
Which has "conversionRate"
This is the revenue data:Example 1 : Store 6, the revenue is 68,487,038 IDR and it should be 4,775.8574 USD
Example 2: Store 4 has 15,392.57 MYR revenue. It should be 3,678.466 USD
Maybe you can take a look at the sample :Example 2.pbix (dropbox.com)
Thank you
- TheoC
Community Champion
hi Anonymous
check this out. Should help you: https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/
Hope this helps!
Theo
- v-luwang-msft
Community Support
Hi Anonymous ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.Best Regards
Lucien
