How to get data that is not exist in other table column

[RanHo]

Good day!

I have sample here , how I can get the numbers in group 1 that is not in group 2 using dax.

thanks in advance!

~Ran

[Kedar_Pande · Accepted solution]

@RanHo 

Create a new Table ( Go to Modeling > New Table )

Write DAX:

Table1_NotIN_Table2 = 
EXCEPT(
VALUES('Table 1'[Column1]),
VALUES('Table 2'[Column2])
)

This will generate a new table showing all numbers that are in Group 1 but not in Group 2.

If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn