Forum Discussion

pat_energetics's avatar
pat_energetics
Icon for Advocate II rankAdvocate II
8 years ago

Create new table with last complete record for each Unit

Hi,   I'm trying to create a new table containing only the latest record for each unique "DUID" in the column DUID of the table shown using the maximum value from the "LastChanged" column. The tab...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

 

Try this one and let me know if you see any issues.

 

New Table = FILTER( Table1, Table1[DUID]= MAX(Table1[DUID]) && Table1[lastChanged]=MAX(Table1[lastChanged]))

 

Thanks
Raj