Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

Dedupe ID - Keep most recent record

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...

Vvelarde
8 years ago
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)

Regards
Victor

Icon for Community Champion rank

Community Champion

8 years ago

Anonymous

This will create you a new Table with the data.

Regards

Victor

Anonymous

Not applicable

8 years ago

Thank you.