give me first date of renewal if renewal else first date

[eliasayyy]

hello everyone ,
i have table :

Business_Name	Term in days	Date Funded	New/Renewal
Homes Reimagined Construction Inc	182	13-Dec-22	Add On
Homes Reimagined Construction Inc	182	26-Aug-22	New
1 Choice Pest Control	157	8-Mar-22	New
3 Amorez	120	20-Jan-22	New
1 Choice Pest Control	132	26-Sep-22	Renewal

i want to create a measure to show me for each business their min date with condition
renewal is stronger than new 
add on is stronger than new

so if the business in the rows have renewal and new like "1 choice pest control",
give me the first date of renewal other

expected result in table visual

Business_Name	First Date
Homes Reimagined Construction Inc	13-Dec-22
3 Amorez	20-Jan-22
1 Choice Pest Control	26-Sep-22

[Anonymous · Accepted solution]

hello @eliasayyy ,
i think you can try something like,

First Date = 
If(
containsstring(ConcatenateX(table[New/Renewal]),"Renewal",
Max(table[Funding Date],
Min(table[Funding Date])