https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/getting-duplicate-value-due-multiple-cell-value-in-the-power/m-p/2349967#M59613 <P>Hi Anonymous</LI-USER>&nbsp;,</P> <P>&nbsp;</P> <P>As&nbsp;<SPAN>&nbsp;<A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/148838" target="_self" aria-label="View Profile of amitchandak">amitchandak</A>&nbsp;mentioned before, there should be duplicate values in&nbsp;RiskDelivey table. In addition to&nbsp;&nbsp;</SPAN></P> <P><SPAN><A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/148838" target="_self" aria-label="View Profile of amitchandak">amitchandak&nbsp;</A>'s reply, you can select all columns in your&nbsp;RiskDelivey table or Merged table, then right click and select "Remove Duplicates"&nbsp;</SPAN></P> <P><SPAN><img /></SPAN></P> <P><SPAN>&nbsp;</SPAN></P> <P>Best Regards,<BR />Rico Zhou</P> <P>&nbsp;</P> <P>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 21 Feb 2022 05:10:14 GMT Anonymous 2022-02-21T05:10:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/getting-duplicate-value-due-multiple-cell-value-in-the-power/m-p/2342129#M59137 <P>i have two table&nbsp; Risk&nbsp; delivery and Excpetion.&nbsp;</P><P>&nbsp;</P><P>RiskDelivey table looks like below&nbsp;</P><P>&nbsp;</P><P>Document No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Inbound&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Actauls&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; QT</P><P>&nbsp;546&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4503213&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 845</P><P>&nbsp;346&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4503413,4502412&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 400&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 445</P><P>&nbsp;246&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4503213,4502321&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 545</P><P>&nbsp;646&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4505213&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;600&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 345</P><P>&nbsp;</P><P>Exception table looks like&nbsp;</P><P>&nbsp;</P><P>&nbsp;Document No&nbsp; &nbsp; &nbsp; &nbsp; Safety time</P><P>&nbsp;&nbsp;546&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34</P><P>&nbsp;&nbsp;346&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23</P><P>&nbsp; 246&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;45</P><P>&nbsp;&nbsp;646&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;78</P><P>&nbsp;</P><P>Now merge two tables in&nbsp; 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.</P><P>&nbsp;</P><P>&nbsp;</P><P>Document No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Inbound&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Actauls&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; QT&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Safety time</P><P>&nbsp;546&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4503213&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 845&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34</P><P>&nbsp;346&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4503413,4502412&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 400&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 445&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;23</P><P>&nbsp;346&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4503413,4502412&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 400&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 445&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23</P><P>&nbsp;246&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4503213,4502321&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 545&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45</P><P>&nbsp;246&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4503213,4502321&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 545&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;45</P><P>&nbsp;646&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4505213&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;600&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 345&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;78</P><P>&nbsp;</P><P>i am getting double line time due&nbsp; inboud cells have two values . how to avoid the duplicates . looking for support.</P><P>&nbsp;</P><P>Thank you..</P> Wed, 16 Feb 2022 12:47:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/getting-duplicate-value-due-multiple-cell-value-in-the-power/m-p/2342129#M59137 Anonymous 2022-02-16T12:47:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/getting-duplicate-value-due-multiple-cell-value-in-the-power/m-p/2342232#M59150 <P>Anonymous</LI-USER> , There should duplicate in one of the tables. Before merge remove duplicate and merge and try </P> Wed, 16 Feb 2022 13:32:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/getting-duplicate-value-due-multiple-cell-value-in-the-power/m-p/2342232#M59150 amitchandak 2022-02-16T13:32:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/getting-duplicate-value-due-multiple-cell-value-in-the-power/m-p/2349967#M59613 <P>Hi Anonymous</LI-USER>&nbsp;,</P> <P>&nbsp;</P> <P>As&nbsp;<SPAN>&nbsp;<A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/148838" target="_self" aria-label="View Profile of amitchandak">amitchandak</A>&nbsp;mentioned before, there should be duplicate values in&nbsp;RiskDelivey table. In addition to&nbsp;&nbsp;</SPAN></P> <P><SPAN><A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/148838" target="_self" aria-label="View Profile of amitchandak">amitchandak&nbsp;</A>'s reply, you can select all columns in your&nbsp;RiskDelivey table or Merged table, then right click and select "Remove Duplicates"&nbsp;</SPAN></P> <P><SPAN><img /></SPAN></P> <P><SPAN>&nbsp;</SPAN></P> <P>Best Regards,<BR />Rico Zhou</P> <P>&nbsp;</P> <P>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 21 Feb 2022 05:10:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/getting-duplicate-value-due-multiple-cell-value-in-the-power/m-p/2349967#M59613 Anonymous 2022-02-21T05:10:14Z