Forum Discussion

rainchong7401's avatar
rainchong7401
Helper III
3 years ago

Find Matching from Multiple Relationship Table

Hi Guys, I'm new to Power BI I hope anyone of you could help me out.  Table 1 is my item ordered quantity. Table 2 is my transaction table which need to make sure quantity is received correctly...
Need Help
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi rainchong7401 
I guess the two tables are related one-many? If so please use

Partial delivery =
VAR RelatedTable2 =
    RELATEDTABLE ( Table2 )
RETURN
    IF (
        SUMX ( RelatedTable2, Table2[Received Quantity] ) = Table1[Received Quantity],
        MAXX ( RelatedTable2, Table2[Partial delivery date] )
    )
rainchong7401's avatar
rainchong7401
Helper III
3 years ago

Hi Tamerj,
This is many many relationship. 
Table 1 primary key is SO
Table 2 primary key is SO too.