Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!! 🙂
Solved! Go to Solution.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
11 | |
11 |