give me first date of renewal if renewal else first date

eliasayyy — Sat, 21 Jan 2023 01:14:10 GMT

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

Re: give me first date of renewal if renewal else first date

Anonymous — Sat, 21 Jan 2023 01:39:06 GMT

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])

topic Re: give me first date of renewal if renewal else first date in DAX Commands and Tips

give me first date of renewal if renewal else first date

Re: give me first date of renewal if renewal else first date