Forum Discussion

k33fun's avatar
k33fun
Frequent Visitor
3 years ago

Lookup % Rebate on another table based on Invoice quantity

Hi, I want to get the correct % Rebate from table A into table B based on the Invoice Qty of each Customer.  How can I get it done via power query? Table A   Table B    
Need Help
kirete17's avatar
kirete17
Frequent Visitor
3 years ago

 

try this

Custom1 = 
        Table.AddColumn(
            Data,
            "Rebate",
            each
                List.Select( 
                    Table.ToRows( Table.ReverseRows( Rebate ) ), 
                    (x)=> x{0} = [Year Channel] and x{1} <= [Invoice Qty] 
                ){0}?{2}? ?? 0
        )
  • k33fun's avatar
    k33fun
    Frequent Visitor
    3 years ago

    Hi Kirete,

     

    Still get the same result, duplicating the records for each customer code with different %Rebate