Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

except

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.  

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    On what conditions do you see them as Invalid entires?

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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.