Forum Discussion
Solved
Multiplying between Tables
This seems like it should be an easy objective but I cannot figure it out. Any help is appreciated. All I want to do is create a New Column that multiplies 2 different rows. The rows exist in two di...
Just to clarify on 1 to many relationships:
* From the "Many" side, you can use RELATED(OneSideTable[Field]) just fine. As there is... only 1 row that will match.
* From the "One" side, you can use RELATEDTABLE(ManySideTable) as get all rows associated with the one side... and do something w/ those rows. eg: =SUMX(RELATEDTABLE(ManySideTable), ManySideTable[Price])
Hi everyone,
I need your support please, I have two tables as shown below for example and I need to multiply values from the two tables together where IDs are equal. Any ideas?
| Table 1 | Table 2 | |||
| ID | Value | ID | Value | |
| x | 1 | y | 4 | |
| y | 2 | z | 5 | |
| z | 3 | x | 6 |