I have a list of Visitor IDs to a website for a specific timespan. For purposes of summarizing the data, I would like to dedeupe the IDs in the list, keep only the timestamp of the most recent visit. The Visitor ID is a column created from a concatenation DAX statement. Is there a preferred way of doing this?

Anonymous (DAX(SUMMARIZECOLUMNS(analytics_clickstream_201802[visid_comb);"LastDate":MAX(analytics_clickstream_201802[date_time])))). Replace : with ; If you have problems with ; replace it with , (This is for regional settings) RegardsVictor

Dedupe ID - Keep most recent record | Microsoft Fabric Community

Forum Discussion

Related content

Eliminate duplicate records while keeping the most recent record.

Most Recent Record

Help with deduping code

How can I filter out certain groups of records based on the most recent record's status?

Show most recent record