Hi guys,
as seen on the thread title, I'm trying to create a collection based on a table, adding columns from another table.
The column I want to add is from the Log table, where the title is repeated multiple times, based on the number of communications sent and received.
In my case I need to catch only the last date on the last row for each title of the first table
Currently I've set this formula
ClearCollect(collrequest1;AddColumns('Database: Requests';"Last message";DateValue(Last(Filter('Log Requests';Title = 'Database: Requests'[@Title])).'Date')))
Any help?

Report
All responses (
Answers (