Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
Anonymous
Not applicable

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. 

IGotTheP0werBI_0-1674572592480.png

What I am needing

Item Code WO_DueDate
00-20046312/16/2022

 

Many thanks in advance!! 🙂

1 ACCEPTED SOLUTION
olgad
Super User
Super User

Hi,
you can use this approach to create a column Earliest date in Power Query.

Transform-Group by-Grouping by Item

olgad_0-1674575277021.pngolgad_1-1674575327304.pngolgad_2-1674575361993.png

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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. 

IGotTheP0werBI_0-1674576843580.png

Is there a way to accomplish this in a measure form?

olgad
Super User
Super User

Hi,
you can use this approach to create a column Earliest date in Power Query.

Transform-Group by-Grouping by Item

olgad_0-1674575277021.pngolgad_1-1674575327304.pngolgad_2-1674575361993.png

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.