Forum Discussion
Get earliest date by condition
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
2 Replies
Hi,
you can use this approach to create a column Earliest date in Power Query.
Transform-Group by-Grouping by Item