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 ...
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]
)
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