Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
4.8k views
in Power BI by 35 41 48

In Power BI, I have two tables and I need to generate a new table that includes only the records from table 1 that not match with any record in table 2

Customer Table

filtering out records that don't exist in another table in Power bi

Sales Table

power bi find all ids not in other tables

The difference Table should have the records in Table 1 Not in Table 2

ID Name
3 Malto

How can I get the difference table between two tables in Power BI?


1 Answer

1 like 0 dislike
by 155 174 350
selected by
 
Best answer

You can simply use the below DAX formula to get rows in Table1 and not have corresponding rows in Table2 using DAX in Power BI

Difference Table = FILTER(Customer,NOT(CONTAINS(Sales,Sales[CustomerID],Customer[ID])))

See also Power BI: RELATED Vs LOOKUPVALUE DAX

by 35 41 48
0 0
Worked like Charm, Many Thanks!
If you don’t ask, the answer is always NO!
...