Forum Discussion
Matas
Advocate II
4 years agoCreating and Switching between Currencies
Hi, I would like to get a suggestion for my issue. Currently, I am receiving many documents in different reporting currencies. So my calculations are as follows: I am receiving documents with d...
- 4 years ago
Matas , A very similar topics ha been solved here, see if that can help
https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/
speedramps
Super User
4 years agoChange your GBP, EUR and DOL queries to a merge with the exchange rate file.
The amounts as a new base currency column eg all GBP.
Then create a Currency pick list table
| Currency | Exchangerate |
| GBP | 1 |
| EUR | 1.19 |
| DOL | 1.26 |
and this measure
GBPAmount =
SUM(Sales[GMPValue)])
Sales in currency =
VAY myexchangerate= SELECT(picklist(Exchangerate))
RETURN
[GBPAmount] * myexchangerate
The either add a slicer with the picklist(Currency)
or use the filter menu to specify the picklist(Currency) for each visual.
Drag the [Sales in currency] to your visual and it should work.
Please click thumbs up and Accepot As Solution, thank you !