Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get Latest Entry

Hey everyone,  I have a new problem to solve. My data looks like this: Serialnumber LastModified ProductID 134567 1. 2. 2020 THXY22 1869999 1. 2. 2020 THXY22 347584 1. 2. 2...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , I would prefer to create these two columns and old is that can be deleted

     

     

    Key = right([Serialnumber], len([Serialnumber])-5)

    new column =
    if([LastModified]= maxx(filter(table , [Key] = earlier([Key]) && [ProductID] = earlier([ProductID])),[LastModified]) ,"Latest","Old")

     

    See if this works for you

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Create a Table

 

Table1 =
SUMMARIZE (
    Table,
    Table[Product id],
    "LAST Date", LASTNONBLANKVALUE (
        Table[Last Modified],
        MAX ( Table[Last Modified] )
    ),
    "Serial No", LASTNONBLANKVALUE (
        Table[Last Modified],
        MAX ( Table[Serial No] )
    )
)

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)