topic Re: Remove duplicates from several varibles in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Remove-duplicates-from-several-varibles/m-p/4127322#M163903 <P>Hi Ibendlin, thanks for helping me, I don´t have problem using Power query</P><P>This is all I have; there are more than 100 employees, but they have the same data.</P><P>In this case, the only difference is that one column may be missing dates, which can happen.</P><P>So, the logic is the same: each employee must have a unique sequence and be the most recent among the three dates. The rows should also maintain Filter Address=1 and Status=ERROR_TIMBRE. For the rows that meet these criteria, indicate 'Keep', and for those that do not, indicate 'Remove'.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>number_of_people</TD><TD>sequence_number</TD><TD>modified_date</TD><TD>payment_date</TD><TD>creation_date</TD><TD>Filter Address</TD><TD>status</TD><TD>Result</TD><TD>32000120</TD><TD>15</TD><TD>12/26/2023</TD><TD>6/14/2024</TD><TD>6/13/2024</TD><TD>0</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD><TD>32000120</TD><TD>15</TD><TD>1/4/2024</TD><TD>6/14/2024</TD><TD>6/13/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32000120</TD><TD>16</TD><TD>12/26/2023</TD><TD>6/28/2024</TD><TD>6/27/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD><TD>32000120</TD><TD>16</TD><TD>1/4/2024</TD><TD>6/28/2024</TD><TD>6/27/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>23</TD><TD>2/22/2024</TD><TD>&nbsp;</TD><TD>6/7/2024</TD><TD>0</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD><TD>32001297</TD><TD>23</TD><TD>2/22/2024</TD><TD>&nbsp;</TD><TD>6/12/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD><TD>32001297</TD><TD>23</TD><TD>2/25/2024</TD><TD>&nbsp;</TD><TD>6/7/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD><TD>32001297</TD><TD>23</TD><TD>2/25/2024</TD><TD>&nbsp;</TD><TD>6/12/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>29</TD><TD>2/22/2024</TD><TD>6/14/2024</TD><TD>6/14/2024</TD><TD>0</TD><TD>Emitido</TD><TD>&nbsp;</TD><TD>32001297</TD><TD>29</TD><TD>2/25/2024</TD><TD>6/14/2024</TD><TD>6/14/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>30</TD><TD>2/22/2024</TD><TD>6/21/2024</TD><TD>6/21/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD><TD>32001297</TD><TD>30</TD><TD>2/25/2024</TD><TD>6/21/2024</TD><TD>6/21/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>31</TD><TD>2/22/2024</TD><TD>6/28/2024</TD><TD>6/28/2024</TD><TD>0</TD><TD>Emitido</TD><TD>&nbsp;</TD><TD>32001297</TD><TD>31</TD><TD>2/25/2024</TD><TD>6/28/2024</TD><TD>6/28/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Expected results</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>number_of_people</TD><TD>sequence_number</TD><TD>modified_date</TD><TD>payment_date</TD><TD>creation_date</TD><TD>Filter Address</TD><TD>status</TD><TD>Result</TD><TD>32000120</TD><TD>15</TD><TD>1/4/2024</TD><TD>6/14/2024</TD><TD>6/13/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32000120</TD><TD>16</TD><TD>1/4/2024</TD><TD>6/28/2024</TD><TD>6/27/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>23</TD><TD>2/25/2024</TD><TD>&nbsp;</TD><TD>6/12/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>29</TD><TD>2/25/2024</TD><TD>6/14/2024</TD><TD>6/14/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>30</TD><TD>2/25/2024</TD><TD>6/21/2024</TD><TD>6/21/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>31</TD><TD>2/25/2024</TD><TD>6/28/2024</TD><TD>6/28/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR></TBODY></TABLE><P><img /></P> Fri, 30 Aug 2024 16:45:53 GMT MichelleRA_24 2024-08-30T16:45:53Z Remove duplicates from several varibles https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Remove-duplicates-from-several-varibles/m-p/4125454#M163826 <P>Hi team!</P><P>I hope you are doing great! I thanks for your support.</P><P>&nbsp;</P><P>I need your help to figure out how to create a logic that results in the "Result" column, considering the number_of_people,</P><P>sequence_number,</P><P>payment_date,</P><P>modified_date,</P><P>creation_date,</P><P>Filter Address=1,&nbsp;</P><P>status=ERROR_TIMBRE.</P><P>If the sequence number is the same for an employee, keep a line that meets the Address Filter = 1 and status = ERROR_TIMBRE, and use the most recent date from any of the 3 date columns. If the employee has different sequence numbers and some are repeated, do the same, making sure to keep the line with the most recent date compared to the others</P><TABLE><TBODY><TR><TD>number_of_people</TD><TD>sequence_number</TD><TD>modified_date</TD><TD>payment_date</TD><TD>creation_date</TD><TD>Filter Address</TD><TD>status</TD><TD>Result</TD></TR><TR><TD>32000127</TD><TD>1</TD><TD>12/28/2023</TD><TD>6/3/2024</TD><TD>6/3/2024</TD><TD>0</TD><TD>ERROR_TIMBRE</TD><TD>Remove</TD></TR><TR><TD>32000127</TD><TD>1</TD><TD>1/4/2024</TD><TD>6/3/2024</TD><TD>6/3/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Remove</TD></TR><TR><TD>32000127</TD><TD>1</TD><TD>5/31/2024</TD><TD>6/3/2024</TD><TD>6/3/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32000185</TD><TD>11</TD><TD>12/26/2023</TD><TD>5/15/2024</TD><TD>6/7/2024</TD><TD>0</TD><TD>ERROR_TIMBRE</TD><TD>Remove</TD></TR><TR><TD>32000185</TD><TD>11</TD><TD>12/26/2023</TD><TD>5/15/2024</TD><TD>6/12/2024</TD><TD>0</TD><TD>ERROR_TIMBRE</TD><TD>Remove</TD></TR><TR><TD>32000185</TD><TD>11</TD><TD>12/26/2023</TD><TD>5/15/2024</TD><TD>6/13/2024</TD><TD>0</TD><TD>Emitido</TD><TD>Remove</TD></TR><TR><TD>32000185</TD><TD>11</TD><TD>6/12/2024</TD><TD>5/15/2024</TD><TD>6/7/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Remove</TD></TR><TR><TD>32000185</TD><TD>11</TD><TD>6/12/2024</TD><TD>5/15/2024</TD><TD>6/12/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32000185</TD><TD>11</TD><TD>6/12/2024</TD><TD>5/15/2024</TD><TD>6/13/2024</TD><TD>1</TD><TD>Emitido</TD><TD>Remove</TD></TR><TR><TD>32000185</TD><TD>12</TD><TD>12/26/2023</TD><TD>5/30/2024</TD><TD>6/7/2024</TD><TD>0</TD><TD>ERROR_TIMBRE</TD><TD>Remove</TD></TR><TR><TD>32000185</TD><TD>12</TD><TD>12/26/2023</TD><TD>5/30/2024</TD><TD>6/12/2024</TD><TD>0</TD><TD>ERROR_TIMBRE</TD><TD>Remove</TD></TR><TR><TD>32000185</TD><TD>12</TD><TD>12/26/2023</TD><TD>5/30/2024</TD><TD>6/13/2024</TD><TD>0</TD><TD>Emitido</TD><TD>Remove</TD></TR><TR><TD>32000185</TD><TD>12</TD><TD>6/12/2024</TD><TD>5/30/2024</TD><TD>6/7/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Remove</TD></TR><TR><TD>32000185</TD><TD>12</TD><TD>6/12/2024</TD><TD>5/30/2024</TD><TD>6/12/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32000185</TD><TD>12</TD><TD>6/12/2024</TD><TD>5/30/2024</TD><TD>6/13/2024</TD><TD>1</TD><TD>Emitido</TD><TD>Remove</TD></TR><TR><TD>32000185</TD><TD>13</TD><TD>12/26/2023</TD><TD>6/14/2024</TD><TD>6/13/2024</TD><TD>0</TD><TD>Emitido</TD><TD>Remove</TD></TR><TR><TD>32000185</TD><TD>13</TD><TD>6/12/2024</TD><TD>6/14/2024</TD><TD>6/13/2024</TD><TD>1</TD><TD>Cancelado</TD><TD>Remove</TD></TR><TR><TD>32000185</TD><TD>14</TD><TD>12/26/2023</TD><TD>6/28/2024</TD><TD>6/27/2024</TD><TD>0</TD><TD>Emitido</TD><TD>Remove</TD></TR><TR><TD>32000185</TD><TD>14</TD><TD>6/12/2024</TD><TD>6/28/2024</TD><TD>6/27/2024</TD><TD>1</TD><TD>Emitido</TD><TD>Remove</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Table name: Secuencias</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Expected results</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>number_of_people</TD><TD>sequence_number</TD><TD>modified_date</TD><TD>payment_date</TD><TD>creation_date</TD><TD>Filter Address</TD><TD>status</TD><TD>Result</TD></TR><TR><TD>32000127</TD><TD>1</TD><TD>5/31/2024</TD><TD>6/3/2024</TD><TD>6/3/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32000185</TD><TD>11</TD><TD>6/12/2024</TD><TD>5/15/2024</TD><TD>6/12/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32000185</TD><TD>12</TD><TD>6/12/2024</TD><TD>5/30/2024</TD><TD>6/12/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 29 Aug 2024 17:36:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Remove-duplicates-from-several-varibles/m-p/4125454#M163826 MichelleRA_24 2024-08-29T17:36:32Z Re: Remove duplicates from several varibles https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Remove-duplicates-from-several-varibles/m-p/4125853#M163845 <P>You posted this in the DAX section. Is it ok to do this via Power Query instead?</P> <P>&nbsp;</P> <LI-CODE lang="markup">making sure to keep the line with the most recent date compared to the others</LI-CODE> <P>&nbsp;</P> <P>That is a very ambiguous requirement. Your sample data only has two rows per group.&nbsp; Please provide better sample data.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <LI-CODE lang="markup">let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("rZTLCoMwEEX/xbWQZJKo6xYXpZRC6E6kSJuFUGsXpd/fBBEf0TxsF4GJymHuPWBRRBQwxgTSKI6IPoAgQ4CBqkuCqB7ZdMTq5EKcxfVyOO1Erq5CNu1HRmVs8hBbQIxGEkLjiJJg3FHK1wiWcf1ZnzXps3JE+MBLQ8J6EfWrfyOnSpr6Xd9bO228x0piHyE+wOF5iBMLb+rYlRbM7ij+SbCDuEWwCxkmGIz+FhP7C7YDwwU7eGGC6bw7RWCbu6Oz1dZgerV99bzJR2XDMXO57rfa8SANWm7e9xpsubfyCw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [number_of_people = _t, sequence_number = _t, modified_date = _t, payment_date = _t, creation_date = _t, #"Filter Address" = _t, status = _t, Result = _t]), #"Filtered Rows" = Table.SelectRows(Source, each ([status] = "ERROR_TIMBRE") and ([Filter Address] = "1")), #"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"modified_date", type date}, {"payment_date", type date}, {"creation_date", type date}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Max Date", (k)=&gt; let f = Table.SelectRows(#"Changed Type", each [number_of_people]=k[number_of_people] and [sequence_number]=k[sequence_number]) in List.Max(List.Combine({f[modified_date],f[payment_date],f[creation_date]}))) in #"Added Custom"</LI-CODE> <P>&nbsp;</P> Fri, 30 Aug 2024 00:54:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Remove-duplicates-from-several-varibles/m-p/4125853#M163845 lbendlin 2024-08-30T00:54:40Z Re: Remove duplicates from several varibles https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Remove-duplicates-from-several-varibles/m-p/4127322#M163903 <P>Hi Ibendlin, thanks for helping me, I don´t have problem using Power query</P><P>This is all I have; there are more than 100 employees, but they have the same data.</P><P>In this case, the only difference is that one column may be missing dates, which can happen.</P><P>So, the logic is the same: each employee must have a unique sequence and be the most recent among the three dates. The rows should also maintain Filter Address=1 and Status=ERROR_TIMBRE. For the rows that meet these criteria, indicate 'Keep', and for those that do not, indicate 'Remove'.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>number_of_people</TD><TD>sequence_number</TD><TD>modified_date</TD><TD>payment_date</TD><TD>creation_date</TD><TD>Filter Address</TD><TD>status</TD><TD>Result</TD><TD>32000120</TD><TD>15</TD><TD>12/26/2023</TD><TD>6/14/2024</TD><TD>6/13/2024</TD><TD>0</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD><TD>32000120</TD><TD>15</TD><TD>1/4/2024</TD><TD>6/14/2024</TD><TD>6/13/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32000120</TD><TD>16</TD><TD>12/26/2023</TD><TD>6/28/2024</TD><TD>6/27/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD><TD>32000120</TD><TD>16</TD><TD>1/4/2024</TD><TD>6/28/2024</TD><TD>6/27/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>23</TD><TD>2/22/2024</TD><TD>&nbsp;</TD><TD>6/7/2024</TD><TD>0</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD><TD>32001297</TD><TD>23</TD><TD>2/22/2024</TD><TD>&nbsp;</TD><TD>6/12/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD><TD>32001297</TD><TD>23</TD><TD>2/25/2024</TD><TD>&nbsp;</TD><TD>6/7/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD><TD>32001297</TD><TD>23</TD><TD>2/25/2024</TD><TD>&nbsp;</TD><TD>6/12/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>29</TD><TD>2/22/2024</TD><TD>6/14/2024</TD><TD>6/14/2024</TD><TD>0</TD><TD>Emitido</TD><TD>&nbsp;</TD><TD>32001297</TD><TD>29</TD><TD>2/25/2024</TD><TD>6/14/2024</TD><TD>6/14/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>30</TD><TD>2/22/2024</TD><TD>6/21/2024</TD><TD>6/21/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD><TD>32001297</TD><TD>30</TD><TD>2/25/2024</TD><TD>6/21/2024</TD><TD>6/21/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>31</TD><TD>2/22/2024</TD><TD>6/28/2024</TD><TD>6/28/2024</TD><TD>0</TD><TD>Emitido</TD><TD>&nbsp;</TD><TD>32001297</TD><TD>31</TD><TD>2/25/2024</TD><TD>6/28/2024</TD><TD>6/28/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Expected results</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>number_of_people</TD><TD>sequence_number</TD><TD>modified_date</TD><TD>payment_date</TD><TD>creation_date</TD><TD>Filter Address</TD><TD>status</TD><TD>Result</TD><TD>32000120</TD><TD>15</TD><TD>1/4/2024</TD><TD>6/14/2024</TD><TD>6/13/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32000120</TD><TD>16</TD><TD>1/4/2024</TD><TD>6/28/2024</TD><TD>6/27/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>23</TD><TD>2/25/2024</TD><TD>&nbsp;</TD><TD>6/12/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>29</TD><TD>2/25/2024</TD><TD>6/14/2024</TD><TD>6/14/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>30</TD><TD>2/25/2024</TD><TD>6/21/2024</TD><TD>6/21/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD><TD>32001297</TD><TD>31</TD><TD>2/25/2024</TD><TD>6/28/2024</TD><TD>6/28/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR></TBODY></TABLE><P><img /></P> Fri, 30 Aug 2024 16:45:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Remove-duplicates-from-several-varibles/m-p/4127322#M163903 MichelleRA_24 2024-08-30T16:45:53Z Re: Remove duplicates from several varibles https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Remove-duplicates-from-several-varibles/m-p/4127325#M163904 <TABLE><TBODY><TR><TD>number_of_people</TD><TD>sequence_number</TD><TD>modified_date</TD><TD>payment_date</TD><TD>creation_date</TD><TD>Filter Address</TD><TD>status</TD><TD>Result</TD></TR><TR><TD>32000120</TD><TD>15</TD><TD>12/26/2023</TD><TD>6/14/2024</TD><TD>6/13/2024</TD><TD>0</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD></TR><TR><TD>32000120</TD><TD>15</TD><TD>1/4/2024</TD><TD>6/14/2024</TD><TD>6/13/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32000120</TD><TD>16</TD><TD>12/26/2023</TD><TD>6/28/2024</TD><TD>6/27/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD></TR><TR><TD>32000120</TD><TD>16</TD><TD>1/4/2024</TD><TD>6/28/2024</TD><TD>6/27/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32001297</TD><TD>23</TD><TD>2/22/2024</TD><TD>&nbsp;</TD><TD>6/7/2024</TD><TD>0</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD></TR><TR><TD>32001297</TD><TD>23</TD><TD>2/22/2024</TD><TD>&nbsp;</TD><TD>6/12/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD></TR><TR><TD>32001297</TD><TD>23</TD><TD>2/25/2024</TD><TD>&nbsp;</TD><TD>6/7/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD></TR><TR><TD>32001297</TD><TD>23</TD><TD>2/25/2024</TD><TD>&nbsp;</TD><TD>6/12/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32001297</TD><TD>29</TD><TD>2/22/2024</TD><TD>6/14/2024</TD><TD>6/14/2024</TD><TD>0</TD><TD>Emitido</TD><TD>&nbsp;</TD></TR><TR><TD>32001297</TD><TD>29</TD><TD>2/25/2024</TD><TD>6/14/2024</TD><TD>6/14/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32001297</TD><TD>30</TD><TD>2/22/2024</TD><TD>6/21/2024</TD><TD>6/21/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>&nbsp;</TD></TR><TR><TD>32001297</TD><TD>30</TD><TD>2/25/2024</TD><TD>6/21/2024</TD><TD>6/21/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32001297</TD><TD>31</TD><TD>2/22/2024</TD><TD>6/28/2024</TD><TD>6/28/2024</TD><TD>0</TD><TD>Emitido</TD><TD>&nbsp;</TD></TR><TR><TD>32001297</TD><TD>31</TD><TD>2/25/2024</TD><TD>6/28/2024</TD><TD>6/28/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Expected results</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>number_of_people</TD><TD>sequence_number</TD><TD>modified_date</TD><TD>payment_date</TD><TD>creation_date</TD><TD>Filter Address</TD><TD>status</TD><TD>Result</TD></TR><TR><TD>32000120</TD><TD>15</TD><TD>1/4/2024</TD><TD>6/14/2024</TD><TD>6/13/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32000120</TD><TD>16</TD><TD>1/4/2024</TD><TD>6/28/2024</TD><TD>6/27/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32001297</TD><TD>23</TD><TD>2/25/2024</TD><TD>&nbsp;</TD><TD>6/12/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32001297</TD><TD>29</TD><TD>2/25/2024</TD><TD>6/14/2024</TD><TD>6/14/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32001297</TD><TD>30</TD><TD>2/25/2024</TD><TD>6/21/2024</TD><TD>6/21/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR><TR><TD>32001297</TD><TD>31</TD><TD>2/25/2024</TD><TD>6/28/2024</TD><TD>6/28/2024</TD><TD>1</TD><TD>ERROR_TIMBRE</TD><TD>Keep</TD></TR></TBODY></TABLE> Fri, 30 Aug 2024 16:47:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Remove-duplicates-from-several-varibles/m-p/4127325#M163904 MichelleRA_24 2024-08-30T16:47:47Z Re: Remove duplicates from several varibles https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Remove-duplicates-from-several-varibles/m-p/4127356#M163907 <LI-CODE lang="markup">and be the most recent among the three dates</LI-CODE> <P>That's the ambiguous statement - I think what you really want is "the most recent date in one of the columns if the other column have matching dates".&nbsp; Or something like that - sequence number 23 seems to be even more complex.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> Fri, 30 Aug 2024 17:20:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Remove-duplicates-from-several-varibles/m-p/4127356#M163907 lbendlin 2024-08-30T17:20:20Z Re: Remove duplicates from several varibles https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Remove-duplicates-from-several-varibles/m-p/4129169#M163980 <P>Thanks for the reply from lbendlin&nbsp;, please allow me to provide another insight:&nbsp;<BR />Hi&nbsp; <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="765986" data-lia-user-login="MichelleRA_24" class="lia-mention lia-mention-user">MichelleRA_24</a>&nbsp;,</P> <P>&nbsp;</P> <P>Here are the steps you can follow：</P> <P>1. Create calculated column.</P> <LI-CODE lang="markup">Result_test = var _modifieddate= MAXX( FILTER(ALL('Test'), 'Test'[number_of_people]=EARLIER('Test'[number_of_people])&amp;&amp;'Test'[Filter Address]=1&amp;&amp;'Test'[status]="ERROR_TIMBRE"&amp;&amp; 'Test'[modified_date]&lt;=TODAY()),[modified_date]) var _count= COUNTX( FILTER(ALL('Test'),[number_of_people]=EARLIER('Test'[number_of_people])&amp;&amp;'Test'[sequence_number]=EARLIER('Test'[sequence_number])&amp;&amp;[modified_date]=_modifieddate),[number_of_people]) var _creationdate= MAXX( FILTER(ALL('Test'), 'Test'[number_of_people]=EARLIER('Test'[number_of_people])&amp;&amp;'Test'[Filter Address]=1&amp;&amp;'Test'[status]="ERROR_TIMBRE"&amp;&amp;'Test'[sequence_number]=EARLIER('Test'[sequence_number])&amp;&amp; 'Test'[creation_date]&lt;=TODAY()),[creation_date]) return IF( _count=1&amp;&amp;'Test'[modified_date]=_modifieddate,"Keep", IF( _count&gt;1&amp;&amp;'Test'[modified_date]=_modifieddate&amp;&amp;'Test'[creation_date]=_creationdate,"Keep",BLANK()))</LI-CODE> <P>2. Create calculated table.</P> <LI-CODE lang="markup">Table = FILTER( 'Test',[Result_test]="Keep")</LI-CODE> <P>3. Result:</P> <P><img /></P> <P>Best Regards,</P> <P>Liu Yang</P> <P>If this post <STRONG>helps</STRONG>, then please consider <EM>Accept it as the solution</EM> to help the other members find it more quickly</P> Mon, 02 Sep 2024 08:24:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Remove-duplicates-from-several-varibles/m-p/4129169#M163980 Anonymous 2024-09-02T08:24:08Z