except

Anonymous · ‎07-02-2018

I have two tables. The first user provided table name is Budget and it has a Customer column and a Budget Sales Amount column. The second table is Customer Master and it has a Customer column and SalesRep column. Problem: I have instances where the user provided Budget table has Customer Numbers that are not valid in the system Customer table. What would be the easiest way in Power BI to get the entries from the user budget table that are invalid.

Thank you for any assistance.

Anonymous · ‎07-02-2018

On what conditions do you see them as Invalid entires?

Anonymous · ‎07-02-2018

They are invalid entries when the spreadsheet has a customer number in it that the Customer Master does not have in it. Perhaps it was something as simple as a data error entry in the spreadsheet or the Customer Master record has not yet been created.