cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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
Solution Sage
Solution Sage

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!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

2 REPLIES 2

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
Solution Sage
Solution Sage

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!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.