Mark smallest date value in group

[MattRoed]

I want to create a column similar to the far right one in this table:

Location	Iteration	Date	Starter
A	1	1/1/2020	Y
A	1	1/6/2020	N
A	1	1/14/2020	N
A	2	1/14/2020	Y
A	2	1/17/2020	N
A	2	1/23/2020	N
B	1	1/1/2020	Y
B	1	1/6/2020	N
B	1	1/14/2020	N
B	2	1/14/2020	Y
B	2	1/17/2020	N
B	2	1/23/2020	N

Basically I want to mark the first instance of the new iteration as a Starter "Y". So it would be the smallest date value for the iteration. But there can be multiple iterations marked as 1, but both location A and B should be marked as "Y" for the first #1. Does that make sense?

Thanks in advance!

[v-diye-msft]

Hi @MattRoed 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

[FrankAT]

Hi @MattRoed,

use the following measure:

Regards FrankAT

[MattRoed · Accepted solution]

@FrankAT  I don't believe it is working. All records are marked as "N". The 1st and 2nd record should be marked as "Y". 

[FrankAT]

Hi @MattRoed,

it works with your sample data as expected. Don't hesitate about the CapturTime, it's in german format.

 Regards FrankAT

[MattRoed]

@FrankAT still not working on my end. Not sure what the issue is. Still marking all columns as "N". 

[v-diye-msft]

Hi @MattRoed 

Let me know if below works:

Measure 4 = var a = CALCULATE(MIN('Table (2)'[Date]),ALLSELECTED('Table (2)'),VALUES('Table (2)'[Location]),VALUES('Table (2)'[Iteration]))
return
IF(SELECTEDVALUE('Table (2)'[Date])=a,"Y","N")

 The suggestion from @FrankAT  should be OK, not sure why failed in your scenario, would you mind sharing your dummy pbix that we can check it further? 

[Greg_Deckler]

@MattRoed - See if this helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434

Or perhaps this, See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...