Forum Discussion
find non-matching values
Hi, I have a dataset with the first 3 columns below and I would like to find out the list of invited companies who did not attend in the 4th column below. May I know how can I achieve that in Power B...
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.
lbendlin
Super User
Super UserEXCEPT 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.
thank you!