Forum Discussion

jjmauras's avatar
jjmauras
Advocate II
10 years ago
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...
  • Anonymous's avatar
    Anonymous
    10 years ago

    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])

     

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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])

 

gbarredap's avatar
gbarredap
Regular Visitor
9 years ago

I need a similar solution but I have Many to Many relationship.