Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
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,
Regards
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.
Regards,
Lydia
Hi Lydia,
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
@MK_Aqipa,
I am unable to access the data you shared as it requires permission.
Regards,
Lydia
would you have another idea how to share excel files here in the community?
@MK_Aqipa,
You can share the file via OneDrive or dropbox, make sure the file you share doesn't require access.
Regards,
Lydia
Hi Lydia,
was the download of the data possible? If yes, did you have any luck to look into the data?
Thanks a lot,
BR
@MK_Aqipa,
Please check if the DAX in the PBIX file below returns your expected result.
Regards,
Lydia
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |