Forum Discussion
PBInonpro
3 years agoHelper III
Compare Two Tables
I have two tables, one with a list of all members and the other with a list of last month members.
how do I compare the two lists to identify those who should have one of the following three statuses?:
1) new members to add (on first table / missing from second table)
2) old members to remove (on second table / missing from first table)
3) on both tables (good)
Hi,
I think EXCEP and INTERSECT DAX functions can provide solutinos you need.
Please check the link down below.
1 Reply
- Jihwan_KimSuper User
Hi,
I think EXCEP and INTERSECT DAX functions can provide solutinos you need.
Please check the link down below.