Forum Discussion

PowerBIUser9901's avatar
PowerBIUser9901
Advocate 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] ) )
        )
    )
)
parry2k's avatar
parry2k
Super User
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
Advocate II
7 years ago

parry2k  That DAX formula you created does exactly what I was looking for. Thank you very much!