Forum Discussion
Digger
Post Patron
Post PatronMultiply 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...
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
amitchandak
Super User
Super UserDigger , using the custom column if you can create 1-M from relation from Table 1 to table 2 then try
Sumx(Table2, DIVIDE(Table2[Amount],related(Table1[Rate])) )
Or add new column in table 2
Rate= related(Table1[Rate])
if needed,
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Diggeramitchandak related(Table1[Rate]) not work as does not see relation as i have other relations on same table