Forum Discussion

Icon for Post Patron rank

Post Patron

7 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...

Icey
6 years ago
Hi KatkaS ,
Please create the columns in Data View or Report View, not Power Query Editor. These are DAX expressions.

Best Regards,
Icey

Icon for Community Support rank

Community Support

6 years ago

If you don't mind, please give me some data sample.

Best Regards
Icey

KatkaS
Post Patron
6 years ago
Hello Icey!

Thank you for your time!
I have two tables and I have to find out that when I deduct the amounts from each other, if I get a zero difference or there is a difference (and how much). The common thing it the Fam line (it is an accounting line) and Company abbreviation. I also need to be able to filter based on Period (I usually have Slicer for this).
The outcome should be Matrix: Company / FAM line / Difference...
KatkaS
Post Patron
6 years ago
- Icey
  Community Support
  6 years ago
  Hi KatkaS ,
  It would be great if you could provide your sample data in Excel.
  
  Best Regards,
  Icey
  - KatkaS
    Post Patron
    6 years ago
    Hello Icey,
    is it ok if I email it to you?
    Thank you.
KatkaS
Post Patron
6 years ago
So in my example above I search for the amounts to compare linked to FAM line (column C) and number in column B (Balance sheet). It must be based on the Operational company (CZC in this case, but there are many more). FAM lines are the same for all the companies.

I hope I'm clearer now..