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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

You can bring the field from one table to another like this if needed

 

 

Max customer = MAXX(filter(Sales,Sales[Order Id]='Item'[Max Sales order id] && Sales[item_id]='Item'[Item ID]),Sales[Customer ID])

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

 

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

Thank you, Amitchandak!

I was not clear enough, I think, could you please check additional information I just posted with screen print?

Thank you very much for your time!