I'm trying to create a currency slicer with multiple exchange rates (on a monthly basis).
I've tried the following formula:
Applicable Exchange Rate = CALCULATE(VALUES(Tabelle1[FX Rate]);FILTER(ALLEXCEPT(Tabelle1;Tabelle1[FCURR]);Tabelle1[TCURR]= SELECTEDVALUE('viewBI JJJJMM01_kunde_marke_lc'[waers]) && Tabelle1[Period - Date Format] = SELECTEDVALUE('viewBI JJJJMM01_kunde_marke_lc'[jjjjmm])))
Revenue in Selected Currency = [Applicable Exchange Rate]*SELECTEDVALUE('viewBI JJJJMM01_kunde_marke_lc'[ums])
however it does not work. Anybody has an idea?
And would it be possible to combine the currency slicer for further measures on the same workbook (f.e. not only slicer for revenue, but also for the order amount, costs,...)?
Thanks a lot for your help,
Could you please share the sample data in a Excel file so that I can copy and paste? Also please post expected result based on the sample data you post.
here the link to the excel file with the two tabs (currency rates + sales). Data Example
the column "waers" in the Sales tab is always in local currency. Based on the respective period + rate, I would like to select with the slicer the sales (column "ums") converted to the different currencies. In addition if possible I would like also other columns (f.e. umsp) converted with the same currency slicer.
many thanks & regards
I am unable to access the data you shared as it requires permission.
You can share the file via OneDrive or dropbox, make sure the file you share doesn't require access.
Please check if the DAX in the PBIX file below returns your expected result.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.