I have (for this example) 2 tables. In each of these tables I have created a key to uniquely identify an employee and a department. Month to month this may change.
What I would like to be able to do is find all the differences between the two tables. So far I have only been able to find the differences based on how I write the M code. I.E. the differences between June and July. But I also need the changes July versus June. As there may be differences as well.
I have attached a sample workbook with 2 small tables. They are loaded into PQ and a third table was created to show the differences.
What I would also like to do is make this dynamic, where I can select which tables I want to compare. I.E. July 2021 v January 2021 ETC. (I think this is done with Parameters within PQ??)
Any help or guidance would be greatly appreciated.
Bookmarks