Forum Discussion
How to do dynamic left anti join?
Hi, I want to perform dynamic left anti join in powerbi. I have an erollment table in which i have user's emails and courses in which users are enrolled in and i have second table called users in w...
Hi,
So if you select abc in the slicer, then in the resultant table, you want the result to be [email protected]. Am i correct? Share some more rows of data in both tables. Also, there should be a third table which should list down all courses. Share that as well.
Hi, Thats correct. I don't have any other table its just the enrollment reports it mostly contains all the courses.
| Course Title | Start Date | Status | |
| [email protected] | abc | Not started | |
| [email protected] | abc | 9/12/21 | completed |
| [email protected] | xyz | 10/1/21 | completed |
| [email protected] | xyz | Not started |
| reporting department | office | Job title | |
| [email protected] | Audit | NSW | Manager |
| [email protected] | IT | QLD | Admin |
| [email protected] | IT | NSW | IT |
| [email protected] | Tax | VIC | tax |
So if i select abc course in slicer I should see [email protected] and [email protected] users who are not enrolled.