The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
69 | |
69 | |
66 | |
54 | |
28 |
User | Count |
---|---|
112 | |
82 | |
66 | |
48 | |
43 |