set analysis get text by max date

[twisster888909]

Hi guys, 

I have an app that contains two tables, the first one is my transaction table, so I have data for all days and I have another table with comments, this table includes comments for some days, not all. So in my final table, I need to show the latest comment by the client.

In this example for client 123, for the max date (24/07/2024) I need to show the comment from 23/07/2024 at 16:50 because is the latest comment for this day, but it currently is showing null.

How can I force the table to show always the latest comment from the time?