Forum Discussion
Solved
Measure using columns from 2 different tables
Hi, I have the following 2 tables - I would like to create a measure which multiply the units from Table1 with the relevant prices from Table2 (considering item and year). I would like to do th...
Both are new column in table1
//new column table 1 price tab1 = maxx(filter(table2,table1[Item]=table2[Item] && table1[year]=table2[year]),table2[Price]) value = [price tab1]*[Units]
Both are new column in table1
//new column table 1
price tab1 = maxx(filter(table2,table1[Item]=table2[Item] && table1[year]=table2[year]),table2[Price])
value = [price tab1]*[Units]
Hi,
Many thanks for your reply, that seems to be the best solution so far. Would you say that the most efficient solution to use?
Hi,
In my way, you do not need to create any relationship.
If my answer has solved your issue, please mark it as a solution for others to see it.
Best Regards,
Giotto Zhi
