Search code examples
powerbidaxpowerquerypowerbi-desktop

Power BI Query To Find List Overlap

I am working on a report in PowerBI to determine which of our current volunteers has registered to volunteer next year.

The data is in a SQL server DB and has the following table structure:

Committees (Committee Info) --Committee Membership (Current Volunteers) --Committee Nominations (Those who have volunteered for next year)

Assuming the relationship between the tables keys are UserID and CommitteeID what would be the easiest way in PowerBi to get a table of Current Members of the committee with a true/false column indicating if they have been nominated this year?

Solution

  • INTERSECT() will do that. But without data, it's harder to tell. You could return a list of PersonID's from Committee Membership table and then a list of PersonID's from the Person table and then it's just

    INTERSECT('Person'[PersonID],Membership[PersonID])