Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
- I have multiple DAX measures which are registered in a currency (for example for revenue, cost etc.)
- I do not like to increase amount of measures because of currencies
- I would like to have slicer switch containing choices "Local" & "EUR"
- Currently all the value columns in fact tables are in local currency.
- Each currency related fact row can be marked with correspondent currency which is then connected to a currency conversion table
-> What should I do to get a working slicer on dashboard with choices "Local" & "EUR" which would then switch the currency for the DAX measures?
Hi @FatherTheWizard ,
It is hard to coding formula from your description without any detail data structure, please share more detail informations to help us clarity your scenario.
How to Get Your Question Answered Quickly
You can also refer to following links about currency handling:
Currency conversion in DAX for Power BI and SSAS
Multiple Currency Logic In Power BI – LOOKUPVALUE Example
Regards,
Xiaoxin Sheng
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |