Return Max date based on multiple condition

hello MiloDi 

output 

measure 1 --  start date 

Start Date = 
var start_date = 
FILTER(
    Tableau1,
    Tableau1[Name] = "AB"
)
return 
MINX(start_date,Tableau1[Date])

measure 2 --  end date

End  Date = 
var count_all =  COUNTROWS(Tableau1)
var end_true = 
FILTER(
    Tableau1,
    Tableau1[Status] = TRUE()
)

 var count_true =  COUNTROWS(end_true)
var res = 
SWITCH(
    TRUE(),
    count_all <> count_true , blank(),
MAXX(end_true,[Date])
)
return  res

let me know if this works for you .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

MiloDi 

modify the code to this : 

End  Date = 
var count_all =  calculate(COUNTROWS(Tableau1) , REMOVEFILTERS(Tableau1[Status]))
var end_true = 
FILTER(
    Tableau1,
    Tableau1[Status] = TRUE()
)

 var count_true =  COUNTROWS(end_true)
var res = 
SWITCH(
    TRUE(),
    count_all <> count_true , blank(),
MAXX(end_true,[Date])
)
return  res

let me know if this helps ....

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠