Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
On what conditions do you see them as Invalid entires?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |