Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jacquelineq
Helper I
Helper I

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 BI? Thanks!

 

jacquelineq_2-1693472805119.png

 

 

1 ACCEPTED SOLUTION

First step is to separate your data into the proper structure

 

Invited:

lbendlin_0-1694177694904.png

 

Attended:

lbendlin_1-1694177714939.png

And then you can use EXCEPT to create your new table

lbendlin_2-1694177825380.png

 

see attached.

View solution in original post

6 REPLIES 6
lbendlin
Super User
Super User

You 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-...
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/1447...

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. 

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=11600...

First step is to separate your data into the proper structure

 

Invited:

lbendlin_0-1694177694904.png

 

Attended:

lbendlin_1-1694177714939.png

And then you can use EXCEPT to create your new table

lbendlin_2-1694177825380.png

 

see attached.

thank you!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.