Forum Discussion
Reconciliation previous month salary with current month salary multiple columns
Hi, Dears, I am facing issue on reconciliation of salary between two months in power query. Following is a sample data of two months. *** Emp. ID. is unique ...
You may query each month, add Index column to each table and unpivot other than Index columns.
Merge Prev Month and Current Month on Index and Attribute (all from current month), expand and compare each record, finally pivot on Index. Result will be like
All steps are in attached file.
yes