Get a list of differences based on filtered values of two table visuals

[bignadad]

I am working on balancing my G/L entry to my Sales Invoice/Credit

I have these two table visuals shown below

Anytime I find a difference I am exporting each of the top 2 tables (sales/gl) to excel and going a vlookup to find which document no is missing from the other.

I would like to create a table so I can see all document no's that are missing from either table.

[bignadad]

Thank you very much for the response but the problem is the document no might be in the table. The filters are what cause it not to show up on the report when i'm comparing the two tables. So this would have to be based off the filters applied to those table visuals. 

[Anonymous]

Hi @bignadad ,

Here some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:
Table GLEntries

Table SalesInvoices

1.Creat two tables to extract the values from the different Document No columns in the two tables

GL_DocNumbers = DISTINCT(GLEntries[Document No])

Sales_DocNumbers = DISTINCT(SalesInvoices[Document No])

2.Create two more tables to show the missing numbers on each side.

Missing_In_Sales = EXCEPT(GL_DocNumbers, Sales_DocNumbers)

Missing_In_GL = EXCEPT(Sales_DocNumbers, GL_DocNumbers)

3.Final output

Best regards

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly