Forum Discussion

dwuorbis's avatar
dwuorbis
Regular Visitor
8 years ago
Solved

Excurr

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! :)

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    dwuorbis,

     

    You may add a calculated column first.

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

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    dwuorbis,

     

    You may add a calculated column first.

    Column =
LOOKUPVALUE (
    Table2[Quote],
    Table2[FromCurr], Table1[Currency],
    Table2[TOCurr], Table1[TOCurr]
)
    • adieball's avatar
      adieball
      Helper I
      8 years ago

      Hi Sam

       

      thanks a lot.

      This is exactly what I have found in parralel.

       

      Andre