Forum Discussion

KatkaS's avatar
KatkaS
Icon for Post Patron rankPost Patron
6 years ago
Solved

Vlookup and calculation

Hello, I'm struggling with following: I have two tables and I need to calculate the difference between amounts in two columns (one in each table), based on the FAM line (4+ digit number).   Coul...
Need Help
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi.

 

  • Load both tables into Power Query.
  • Prepare your key column.
  • Merge the Queries
  • Calculate the difference

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

KatkaS's avatar
KatkaS
Icon for Post Patron rankPost Patron
6 years ago

Thank you for your support!

But I don't understand how merging could help, perhaps I'm missing something? One column is the common information for both tables and I would need to calculate if there is a difference in the amounts based on that information and operational company.

I tried to explain myself better in detail below.

Thank you for checking this!