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 .
Go to Solution.
@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).
View solution in original post
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!