Forum Discussion

tejapowerbi123's avatar
tejapowerbi123
Icon for Helper V rankHelper V
7 years ago
Solved

Lookup with Duplicate records

Hello,

i want to copy records from lookup table to main table, main table ID column has duplicate records and i want to copy all the discount from lookup to all percentage column.

I tried lookup and due to duplicate records it did not pull any records.

Please suggest me .

 

 

 

 

 

 

 

 

Need Help
  • otravers's avatar
    otravers
    7 years ago

    tejapowerbi123 You can do this in Power Query by merging the lookup table with the main table using a left join (all values from main, matching values from lookup).

1 Reply

  • otravers's avatar
    otravers
    Icon for Community Champion rankCommunity Champion
    7 years ago

    tejapowerbi123 You can do this in Power Query by merging the lookup table with the main table using a left join (all values from main, matching values from lookup).