Forum Discussion
find non-matching values
First step is to separate your data into the proper structure
Invited:
Attended:
And then you can use EXCEPT to create your new table
see attached.
Super UserYou do that with the EXCEPT() statement in DAX.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi, thanks for your reply. I only have 1 table and the sample data are listed in the image in my original post. Except() expression is used to compare 2 tables if I'm not wrong.
- lbendlin
EXCEPT can compare two table variables, regardless of where these are coming from.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.here's the link to the sample data.. the expected outcome is in column D.. thanks for your help! https://docs.google.com/spreadsheets/d/11hdwFoi5CgAPbBMqm2rQrearlc9IBCyl/edit?usp=sharing&ouid=116009426678856596177&rtpof=true&sd=true
- lbendlin
First step is to separate your data into the proper structure
Invited:
Attended:
And then you can use EXCEPT to create your new table
see attached.