Excurr

[dwuorbis]

Hi guys,

I have a problem with showing the exact values of the target currency, from AUD to EUR in this example. I've added the DAX expression of "ToSales" (value of target currency):

The target value doesn't match with the exchange quote (0,66) of AUD to EUR. (USD to EUR works fine btw)

Thank you in advance for your help! 🙂

[v-chuncz-msft · Accepted solution]

@dwuorbis,

You may add a calculated column first.

Column =
LOOKUPVALUE (
    Table2[Quote],
    Table2[FromCurr], Table1[Currency],
    Table2[TOCurr], Table1[TOCurr]
)

[adieball]

Hi Sam

thanks a lot.

This is exactly what I have found in parralel.

Andre