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?

[BrunPierre]

Try this.

=Only(Aggr(FirstSortedValue(comments, -time), Client))

[Padma123]

join the 2 tables into single table ,sort the data by using 'time'  field,

let vresult=Peek('comments');

after 

If(IsNull(comments),'$(vresult)',comments)