Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi Everyone,
I need Help
based on below tables
ID | Data |
1 | 1/2/2018 |
1 | 1/3/2020 |
2 | 3/2/2008 |
2 | 3/5/2002 |
1 | 2/9/2021 |
3 | 3/7/2003 |
3 | 7/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
ID | Data |
1 | 1/3/2021 |
2 | 3/2/2008 |
3 | 7/8/2005 |
Solved! Go to Solution.
Go to Modeling Table and make New table then use this:
MAXDATABYID = SUMMARIZE(Table1,Table1[ID],"MAXDATE",MAX(Table1[Data]))
Go to Modeling Table and make New table then use this:
MAXDATABYID = SUMMARIZE(Table1,Table1[ID],"MAXDATE",MAX(Table1[Data]))
User | Count |
---|---|
89 | |
70 | |
67 | |
53 | |
27 |