Forum Discussion

dzhogov's avatar
dzhogov
Copper Contributor
Apr 09, 2019
Solved

Specific Power Query Merge help

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...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 09, 2019

    Hi dzhogov ,

     

    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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 09, 2019

Hi dzhogov ,

 

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