Comparing with power automate will be huge task of 102 columns * 27000 rows.
Is there any Identity / Unique Key columns exist in each rows of data ? If yes it will be easy or else you need create a unique column by combine two columns which will serve as Identity.
Load Previous Month → PrevData
Load Current Month → CurrData
Data → Get Data → From Excel → Load to Power Query
Find New Rows (Exists in Current, Not in Previous)
Merge:
- CurrData → Left
- PrevData → Right
Join on Key - Join Kind → Left Anti this Output will provide us New rows added this month
Find Changed Rows (The Important Part)
Step A: Inner Join on Key
Join Current ↔ Previous using Inner Join
Step B: Expand Previous columns
Rename columns clearly: Amount_Curr, Amount_Prev, etc.
Step C: Add a “Changed?” Column
= if [Amount_Curr] <> [Amount_Prev]
or [Status_Curr] <> [Status_Prev]
then "Changed"
else "No Change"
✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.
