Forum Discussion
Filtering Data by mismatches between two columns
Hi Anonymous
Are these two columns in the same table currently? If they are in the same table, you can add a new column to compare them and return a result 1 (match) or 0 (not match).
Then add this column as a filter, set it to show items when the value is 0 (not match). In this way, all data is imported into the data model. Matching items are only invisible from the report.
If you don't want to import matching items into the data model, you can filter them out with Power Query Editor. Click "Transform data" to open Power Query Editor, add a conditional column to compare column1 with column2 and return 1 or 0. Then filter by result column to have rows with 0. In this way, only not-matching items will be imported into your report.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi Anonymous
Are these two columns in the same table currently? If they are in the same table, you can add a new column to compare them and return a result 1 (match) or 0 (not match).
Then add this column as a filter, set it to show items when the value is 0 (not match). In this way, all data is imported into the data model. Matching items are only invisible from the report.
If you don't want to import matching items into the data model, you can filter them out with Power Query Editor. Click "Transform data" to open Power Query Editor, add a conditional column to compare column1 with column2 and return 1 or 0. Then filter by result column to have rows with 0. In this way, only not-matching items will be imported into your report.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thank you so much! This looks like exactly what I need.