Forum Discussion

PowerBIUser9901's avatar
PowerBIUser9901
Icon for Advocate II rankAdvocate II
7 years ago
Solved

Combining tables IF

I need to create a table visual with both Table_1 and Table_2 data merged however If Order_ID is included in Table_1 and Table_2 then only include the Table_1 data.   *Things to note both Table_1 a...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    PowerBIUser9901 try this

     

    Table_Combine = 
UNION 
(
    DISTINCT( Table_1 ),
    DISTINCT(
        CALCULATETABLE(
            Table_2, EXCEPT( VALUES( Table_2[Order_Id] ), VALUES( Table_1[Order_Id] ) )
        )
    )
)
PowerBIUser9901's avatar
PowerBIUser9901
Icon for Advocate II rankAdvocate II
7 years ago

parry2k 

If Table_1 Order_ID has multiple Product codes and Company codes associated to them then the end result should be a table of the same Order_ID repeating for each association such as the Desired Output table I showed above. 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

PowerBIUser9901 I'm bit lost here, the image you showed is after using solution I provided. send excel sheet with sample data and expected result.