Forum Discussion
Filter by currency
Hey there
I created a report in which the user can select currency to see the data. To solve this, I have a table like this:
Date Sales Currency
01/01/2019 10000 ARS
01/01/2019 222 USD
The table shows sales in each single date in both currencies.
Is there any other way to solve this?
Any suggestions?
Regards, Marianela.
Hi mmazzalay ,
You can create a new table named Currency like below:
CurrencyName
Rate
USD
1
ARS
45.05
Assuming to take US dollar as the basic currency rate, let the [CurrencyName] in Currency as the source of Slicer visual. Then you can create a new measure like DAX below.
CurrentSales = IF(ISFILTERED('Currency'[CurrencyName]),SUM(Table1[sales])*VALUES('Currency'[Rate]),SUM(Table1[sales]))Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi mmazzalay ,
You can create a new table named Currency like below:
CurrencyName
Rate
USD
1
ARS
45.05
Assuming to take US dollar as the basic currency rate, let the [CurrencyName] in Currency as the source of Slicer visual. Then you can create a new measure like DAX below.
CurrentSales = IF(ISFILTERED('Currency'[CurrencyName]),SUM(Table1[sales])*VALUES('Currency'[Rate]),SUM(Table1[sales]))Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.