Filtering Data by mismatches between two columns

[mcole95]

Hello,

I'll start by saying that I'm not a data analyst or a developer, I'm just an employee trying their best with totally new software. I've done my best to research what I can but I have not been able to find a way to sort my data in an efficient way.

For context, our IT department was able to create a PowerBi report that pulls the data for individual files in our system daily. The purpose of this report is to find mismatches between data points in our software and our federal reporting software so that we can go in and manually reconcile the two data points so that they match.

So we have separate columns, one column for what our software has and another column for what the federal reporting software is showing for the same item. The only problem is the report is not filtering out the files where there are no mismatches. Is there a way that I can visualize the data or just filter the data so that it only shows me the files where two points that I select do not match?  Please see below for a bit more clarification about what I mean.

I would like to find a way to filter the data so that only the items below that don't match are visible.

Thank you for any help in advance

37.297	37.297
0	39.069
0	0
26.034	26.034
0	29.91
45.42	45.42
0	28.229
39.077	39.077
0	39.589
0	57.84
0	30.906
0	36.817
31.296	31.296
38.851	38.851

[v-jingzhang · Accepted solution]

Hi @mcole95 

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.

[mcole95]

Thank you so much! This looks like exactly what I need.