Jolly Day,
I am needing to create a measure to get the earliest date by Item Code.
I am needing only one result for item code filtered by the earliest date.
I tried using the filter on the visual to get the earliest date but my results go wonky so I am needing to do this in a measure.
What I am currently getting.
What I am needing
| Item Code | WO_DueDate |
| 00-200463 | 12/16/2022 |
Many thanks in advance!! 🙂
Hi,
you can use this approach to create a column Earliest date in Power Query.
Transform-Group by-Grouping by Item
Hi,
I love that Idea! I should have explained more though I am needing it to be a measure because Item code is coming from a table that doesn't directly tie to the table that has WODueDate.
Is there a way to accomplish this in a measure form?
Hi,
you can use this approach to create a column Earliest date in Power Query.
Transform-Group by-Grouping by Item
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.
