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.
If I understood your logic correctly you may merge your main table with PRICE/KG on clients and add new column with condition if [VALUE]=null then [QUANTITY]*[PRICE/KG] else [VALUE], after that remove VALUE and PRICE/KG columns
Best Response confirmed by
dzhogov (Occasional Contributor)