Power Query Big Data Reconciliation 

Yes, I will be posting one on how to reconcile amounts with multiple fields involved. It will be the same basic process, however you create a unique key by concatenating the fields together before the pivot. i.e. Date&"-"&Number&"-"&Department, etc. Then parsing this back out once the zeros are filtered out, to see differences by field.

@@AZAdvancedAnalytics thank you, will wait for it. Please inform when video is available

Hello. If you filter and keep the nulls, you would be excluding the records that were not null, but had different amounts in both columns. However, you could use that method to count records that were in one table and not another.

Hi iankr. I don't think you have to, but working within the data model allows us to build the solution within that virtual space. Then, return just what we need to complete the report within Excel.

@@AZAdvancedAnalytics I was wondering the same thing, if adding to the Data Model was really needed, but thanks for a very interesting approach.

That's a great way to do the same thing! I recorded the "pivot table method" since I thought it would be easier to follow and learn for those already familiar with Excel Tables, and or Pivot Tables.

Indeed. The equivalent of Venn diagrams is PQ are those join types.