Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i have two table Risk delivery and Excpetion.
RiskDelivey table looks like below
Document No Inbound Actauls QT
546 4503213 300 845
346 4503413,4502412 400 445
246 4503213,4502321 500 545
646 4505213 600 345
Exception table looks like
Document No Safety time
546 34
346 23
246 45
646 78
Now merge two tables in power query using left outer join to bring safety time values to Risk table. after that i am getting duplicate due to cell have multiple value.
Document No Inbound Actauls QT Safety time
546 4503213 300 845 34
346 4503413,4502412 400 445 23
346 4503413,4502412 400 445 23
246 4503213,4502321 500 545 45
246 4503213,4502321 500 545 45
646 4505213 600 345 78
i am getting double line time due inboud cells have two values . how to avoid the duplicates . looking for support.
Thank you..
Solved! Go to Solution.
@THENNA_41 , There should duplicate in one of the tables. Before merge remove duplicate and merge and try
Hi @THENNA_41 ,
As amitchandak mentioned before, there should be duplicate values in RiskDelivey table. In addition to
amitchandak 's reply, you can select all columns in your RiskDelivey table or Merged table, then right click and select "Remove Duplicates"
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@THENNA_41 , There should duplicate in one of the tables. Before merge remove duplicate and merge and try
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
48 | |
24 | |
20 | |
14 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |