Add unique values to a column retrieved from multiple tables in PowerBI

Hey Anonymous ,

I use this DAX statement to create a table that contains "unique" values from multiple tables:

New Table = 
DISTNCT(
    UNION(
        ALLNOBLANKROWS( 'table1'[columname] )
        , ALLNOBLANKROWS( 'table2'[columname] )
    )
)

Hopefully, this provides what you are looking for.

Regards,

Tom

Hi Anonymous 

See it all at work in the attached file.

You can create a calculated table in DAX:

Option1 =
DISTINCT (
    UNION (
        DISTINCT ( InventoryT[Article number] ),
        DISTINCT ( MaterialsReceived[Article number] )
    )
)

or create a table in the query editor. Place the following M code in a blank query to see the steps.

let
    T1 = Table.SelectColumns(InventoryT, "Article number"),
    T2 = Table.SelectColumns(MaterialsReceived, "Article number"),
    res_ = Table.Distinct(Table.Combine({T1,T2}))
in
    res_