Hello, I have a very particulate situation within Power Query which I am not sure how to go about.
As a data source for a sales dashboard, I have a table within PQ where I have monthly sales to 5 clients. Each row has
MONTH; CLIENT; PRODUCT; QUANTITY; VALUE.
However, one client uses special discounts which no one else does, and so the VALUE column is empty. I have a sheet with PRICE/KG for the client (including discounts) so the solution is to multiply QUANTITY by this PRICE\KG to result in the correct VALUE. However, I am not sure how to go about merging the two tables so as to match only the CLIENT in question and do the actual multiplication.