Find the date

[09]

Hello all,

For this example below, I wante a DAX measure that returns the change over date from defective to repaired for each ID(the part don't have a unique ID). I tried many formulas but they didn't work for me.

Thanks for your help. 

Date	Part	ID	Designator	change over date
20-avr	A	5022120	repaired	20-avr
19-avr	A	5022120	defective	20-avr
18-avr	A	5022120	defective	20-avr
17-avr	A	5022120	defective	20-avr
20-avr	B	3288286	repaired	19-avr
19-avr	B	3288286	repaired	19-avr
18-avr	B	3288286	defective	19-avr
17-avr	B	3288286	defective	19-avr
20-avr	D	5235789	repaired	19-avr
19-avr	D	5235789	repaired	19-avr
18-avr	D	5235789	defective	19-avr

[09]

Thank you for your help!

It works.

[amitchandak · Accepted solution]

@09 , try a new column like

minx(filter(Table, [ID] =earlier([ID]) && [Part_number] =earlier([Part_number]) && [Designator] ="repaired"), [Date])