find the earliest date based on two columns

[Jboggie46]

I am trying to take the earliest date based on criteria from two other columns. I need to track systems as they complete control testing of subcontrols to satisfy the base control. See example below:

System	Controls	Subcontrol	Date
link	ac-1	ac-1.2	1/15/2020
link	ac-1	ac-1.4	5/5/2021
link	ac-1	ac-1.9	5/6/2021
haltech	sc-2	sc-2.3	2/20/2023
haltech	sc-2	sc-2.4	2/20/2023
haltech	sc-2	sc-2.7	4/2/2023

This is what I am trying to achieve:

System	Controls	Subcontrol	Date	Earliest test date
link	ac-1	ac-1.2	1/15/2020	1/15/2020
link	ac-1	ac-1.4	5/5/2021	1/15/2020
link	ac-1	ac-1.9	5/6/2021	1/15/2020
haltech	sc-2	sc-2.3	2/20/2023	2/20/2023
haltech	sc-2	sc-2.4	2/20/2023	2/20/2023
haltech	sc-2	sc-2.7	4/2/2023	2/20/2023

[Ashish_Mathur]

Hi,

This calculated column formula works

=CALCULATE(MIN(Table1[Date]),FILTER(Table1,Table1[System]=EARLIER(Table1[System])&&Table1[Controls]=EARLIER(Table1[Controls])))

Hope this helps.

[Ahmedx]

pls try