Revenue doubles after a Power Query merge. How would you find and fix the cause?

Instruction: Use the actual source grain and join keys. Describe split payments as a hypothetical example if you have not handled that data.

Context: Locates the multiplication at the transformation step and proposes fixes that preserve valid records and financial totals.

Updated

Official answer available

Read the opening below, then unlock the full answer and practical guidance.

I'd compare the row count, unique order count, and revenue before and after the merge, including the expansion step. A merge can look harmless until I expand a nested table with multiple matches...

Upgrade to view official answer

Related Questions