Forum Discussion

Digger's avatar
Digger
Icon for Post Patron rankPost Patron
5 years ago
Solved

Multiply two tables using userelationship or Treatas

I have to tables Table1 CurrencyRates Name | Rate | Date | Custom  USD | 1,35 | 2021-08-01 | USD2021-08-01 AFN | 0,35 | 2021-08-01 | AFN2021-08-01 BRL| 0,05 | 2021-08-01 | BRL2021-08-01   Tab...
Need Help
Show and Tell
Tips and Tricks
hashtag_pete's avatar
hashtag_pete
Icon for Helper V rankHelper V
5 years ago

Hello Digger, 

have you tried lookupvalue? Something like

Conversion = DIVIDE ( Table2[Amount] , LOOKUPVALUE(Table1[Rate], Table1[Custom], Table2[Custom]))

 

Does that help? If so, please

  • mark this post as a solution
  • give kudos

Thanks hashtag_pete

  • Digger's avatar
    Digger
    Icon for Post Patron rankPost Patron
    5 years ago

    hashtag_pete  does lookup on 10 mil rows is good idea?

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi,  Digger 

      You can take a try the measure  as below:

       

      Measure_PriceinEur = Calculate(DIVIDE(max(Table2[Amount]),MAX(Table1[Rate])), USERELATIONSHIP(Table2[Custom],Table1[Custom]))

       

      Then apply it to a table visualization.

      Best Regards,
      Community Support Team _ Eason