I have this table:
I currently cannot establish a relationship to this table because of duplication. How can I transform this into one record using the earliest start date (1/1/2017) and the latest enddate (12/31/2100)?
Hi @Anonymous,
Please download the solutions from the attachment. You can achieve it either by Power Query or by DAX.
1. Using Power Query "Group by" function.
2. DAX.
Table = SUMMARIZE ( 'Table2', Table2[Co], "startDate", MIN ( 'Table2'[startDate] ), "endDate", MAX ( 'Table2'[endDate] ) )
Best Regards,
Dale
Hi @Anonymous,
Please download the solutions from the attachment. You can achieve it either by Power Query or by DAX.
1. Using Power Query "Group by" function.
2. DAX.
Table = SUMMARIZE ( 'Table2', Table2[Co], "startDate", MIN ( 'Table2'[startDate] ), "endDate", MAX ( 'Table2'[endDate] ) )
Best Regards,
Dale
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
