Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

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
1 ACCEPTED SOLUTION
rocky09
Solution Sage
Solution Sage

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

 

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

View solution in original post

2 REPLIES 2
rocky09
Solution Sage
Solution Sage

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

 

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

Thanks @rocky09.

Smiley Happy

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.