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 Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
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.
