I have a question regarding an extension of the P&L Structure; adding a Slicer that would change the currency. The result should be a slicer, where one can select local currency, Dollar, GBP, etc. so that the values in the specified P&L are calculated accordingly.
The build of the model is as follows:
- One transaction table with all the financial data (in local currency)
- One table with the exchange rates, where column one specifies the curreny name and the second column specifies the exchange rate
- The Structure and DAX-Formulas are pretty much similar to the exmample:
My question is how to integrate the necessary DAX-modification in the “Selected Year Actuals” measure, if at all? Or is there a better way to impelent the Slicer?
Thank you for the great content!