Retrieving the Latest Log Entry for Team Announcements

[exerlanda]

Hi everyone,

I have implemented the template Log Changes in Table. So far it works pretty well and I'm very happy with it. However, I would like to retrieve the last log entry to use the values from the different columns in a team announcement view.

I tried using the MAX() function on the "Last Update" DateTime, but I encountered an error. Could anyone advise me on how to proceed?

Thank you!

[AlexM]

Hi

Virtual column [lastRecord]

ANY(SELECT(tableName[key column], [_ROWNUMBER] = MAX(tableName[_ROWNUMBER])))

Then virtual column for each column you need

[lastRecord].[desiredColumn]

If you want to get the value in one go:

ANY(SELECT(tableName[desiredColumn], [_ROWNUMBER] = MAX(tableName[_ROWNUMBER])))

[exerlanda]

Thank you for your reply. I tried but I got the error "MAX function is used incorrectly"

[AlexM]

Can you share it?

[exerlanda]

Thank you. I'm using a copy of the template Log Changes in Table

[AlexM]

Sorry, I meant the formula you used

[exerlanda]

Here it is:

ANY(SELECT([Log ID],[_RowNumber]= MAX([_RowNumber])))

[AlexM · Accepted solution]

you missed the table names

ANY(SELECT(tableName[Log ID],[_RowNumber]=MAX(tableName[_RowNumber])))

[exerlanda]

I don't know what I was doing wrong but previously the tableName didn't showed up. I tried again adding manually, and it works perfectly. Thanks!