Multiple Currency Conversion + home currency

[heldus]

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

[v-frfei-msft · Accepted 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.

[heldus]

Hi @v-frfei-msft ,

i found a solution for my problem.

Thank you for your offer.

Best regards

[judspud]

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