Choose highest value in Date or Date/Time in rows where values can repeat

[WilliamAzevedo]

Hello, everyone.

I have data where the "main" column repeats (and that is expected, since it's information can change; also, it's source are .xlsx files stored in a SharePoint folder with content daily updated) and I need it to be filtered by the latest or highest data in another column (ideally - suggestions are welcome - a Date or Date/Time Column). Here's the visual where I identified the problem:

As seen, there are 9 registers in the Matrix visual with 5 in the multiline Card. Here's what I believe to be the reason:

I need the quantity of registers in the Matrix visual to reflect that in the Card visual, what is not happening because of these expected repetitions. I thougt about using the "Sit da OS" column as the filter, but, it's a status info and the order of changing is not really solid; I also considered "Encerramento" (meaning Closing, Finishing), but since this is a last step in the process, I don't know how to deal with the rows that eventually still don't have that data and still must be visible.

Thank you in advance for any help!

[WilliamAzevedo · Accepted solution]

Hello again. I followed that instruction and everything seems to be as I expected, so far.

Thank you!