Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Retrieve unique data and max date from table

Hi Everyone,

I need Help

 

based on below tables

IDData
11/2/2018
11/3/2020
23/2/2008
23/5/2002
12/9/2021
33/7/2003
37/8/2005

 

 I want to create a new  calculate a table or any solution to retive max date for each uniqe ID , The resulte must be as the same below table 

IDData
11/3/2021
23/2/2008
37/8/2005
Need Help
  • rocky09's avatar
    rocky09
    7 years ago

    Go to Modeling Table and make New table then use this:

     

    MAXDATABYID = SUMMARIZE(Table1,Table1[ID],"MAXDATE",MAX(Table1[Data]))

2 Replies

  • rocky09's avatar
    rocky09
    Solution Sage
    7 years ago

    Go to Modeling Table and make New table then use this:

     

    MAXDATABYID = SUMMARIZE(Table1,Table1[ID],"MAXDATE",MAX(Table1[Data]))