Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I'm very new to Power BI, working right now on a multiple currency conversion.
The Conversion works so far:
SalesAmount2 = SUMX(SpareParts, SpareParts[SalesAmount],
DIVIDE(SpareParts[SalesAmount],
LOOKUPVALUE(ExchangeRates[ExchaneRate],ExchangeRates[Date],SpareParts[Date],
ExchangeRates[Currency],SpareParts[Currency])))
I´m struggling right now with the problem that the table also contains the home currency and for the home currency I don´t want to add a 1:1 exchange rate because I just want to sum up all the values with the home currency in this Case EUR and add it to the SalesAmount2.
So I´m trying to figure out how i can add to this measure above the possibilty to just sum up the home curreny.
Best regards
Marco
Solved! Go to Solution.
Hi @heldus ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi @heldus ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi @heldus
You could use an if statement to check the currency.
If it is EUR then sum else do the formula you wrote .
Hope this helps
Thanks,
George
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |