Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Trying to Multiply the Value in Rows from Two different tables

I have two different tables. One is a table with Currency rates. The other is a table with my sales orders. I have a relationship built in both tables where the Currency_Month_Year matches on a many ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi Anonymous

     

    Have you tried a calculated column in your SalesTable like this?

     

    New Column = 'SalesTable'[Net Amount] * RELATED('FX Rates'[Value])
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous

 

Have you tried a calculated column in your SalesTable like this?

 

New Column = 'SalesTable'[Net Amount] * RELATED('FX Rates'[Value])