Forum Discussion

gvg's avatar
gvg
Post Prodigy
8 years ago
Solved

List rows that are missing in another table

Hi experts, I am looking for a way to list all rows of one table, that are missing in another table. Specifically I need to check one column in TableA if the value is missing in a column in TableB. ...
Show and Tell
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi gvg

     

    Add a New Table from Modelling Tab

    Missing_IDs =
EXCEPT ( VALUES ( TableA[ProductID] ), VALUES ( TableB[ ProductID] ) )

    Then Add a New Column in this New Table as follows

    Sales =
CALCULATE (
    VALUES ( TableA[ SalesAmount] ),
    FILTER ( TableA, Missing_IDs[ProductID] = TableA[ProductID] )
)


    This will give you desired table

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi gvg

 

Add a New Table from Modelling Tab

Missing_IDs =
EXCEPT ( VALUES ( TableA[ProductID] ), VALUES ( TableB[ ProductID] ) )

Then Add a New Column in this New Table as follows

Sales =
CALCULATE (
    VALUES ( TableA[ SalesAmount] ),
    FILTER ( TableA, Missing_IDs[ProductID] = TableA[ProductID] )
)


This will give you desired table