Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a table that contains a customer_id column which a few thousand entries. I have another table that lists a customer_id column of "bad" ID's that I want to filter OUT OF the first table. The end result would be the first table minus any rows of the "bad" customer_id listed in the second table. Help?
Solved! Go to Solution.
There are likely several ways to do this. I would approach it by adding a calculated column to your first table which tests whether the customer_id is within the second table's list:
Good IDs = IF(Table1[customer_id] in VALUES(Table2[bad_ids]), True, False)
You can edit the True and False outputs to be anything you'd like, and slice by "True" to see only those customers without bad IDs.
I actually got it to work using a version of:
FILTER ( Table1, NOT Table1[Id] IN DISTINCT ( Table2[Id] ) )
It's amazing how much you can learn at Power BI when you are dealing with a crappy data source! 🙂 Thanks All!
I actually got it to work using a version of:
FILTER ( Table1, NOT Table1[Id] IN DISTINCT ( Table2[Id] ) )
It's amazing how much you can learn at Power BI when you are dealing with a crappy data source! 🙂 Thanks All!
There are likely several ways to do this. I would approach it by adding a calculated column to your first table which tests whether the customer_id is within the second table's list:
Good IDs = IF(Table1[customer_id] in VALUES(Table2[bad_ids]), True, False)
You can edit the True and False outputs to be anything you'd like, and slice by "True" to see only those customers without bad IDs.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |