https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-retrieve-unique-case-number-based-on-Message-Date-in/m-p/3718214#M144768 <P>Apply the "Latest" aggregation to the Message Date column.</P> Thu, 22 Feb 2024 21:23:56 GMT lbendlin 2024-02-22T21:23:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-retrieve-unique-case-number-based-on-Message-Date-in/m-p/3716982#M144700 <P>Hello All,&nbsp;<BR /><BR />Can someone please help me to resolve the below issue. I have this table where in message date is the response received on the case number) and date/time closed is when the case was closed.&nbsp;<BR /><BR />I am trying to display only unique casenumber based on the latest message date along with timestamp. As you can see "00854913" case number is displayed twice as the message date timestamp is 6:55 PM &amp; 1:47 PM.&nbsp;&nbsp;<BR /><BR /></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 22 Feb 2024 11:42:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-retrieve-unique-case-number-based-on-Message-Date-in/m-p/3716982#M144700 jssonali 2024-02-22T11:42:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-retrieve-unique-case-number-based-on-Message-Date-in/m-p/3718214#M144768 <P>Apply the "Latest" aggregation to the Message Date column.</P> Thu, 22 Feb 2024 21:23:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Unable-to-retrieve-unique-case-number-based-on-Message-Date-in/m-p/3718214#M144768 lbendlin 2024-02-22T21:23:56Z