Forum Discussion

Leski's avatar
Leski
Frequent Visitor
6 years ago
Solved

Measure multiplying the data from the two tables

Hello I'm begining with DAX and I try to create new measure with calculete price in euro; price in local currency from first table [sales] and currency form second [Currency]. Of course, the tables...
  • AntrikshSharma's avatar
    AntrikshSharma
    6 years ago

    Try something like:

     

    = SUMX ( Sales, Sales[PriceInLocalCurrency Column] * RELATED ( Currency[Currency Column] ) )

     

AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago

Try something like:

 

= SUMX ( Sales, Sales[PriceInLocalCurrency Column] * RELATED ( Currency[Currency Column] ) )

 

Leski's avatar
Leski
Frequent Visitor
6 years ago

Thank you, works great.