Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 .
Solved! 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).
@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).
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |