How to Filter a Max or Min Date based on two different Columns

[JSIQUEI-YYC-ENB]

Hi there,

I have a table with the following columns:

and I would need two meassures:

- One measure to filter the Ealiest Start Date filtered by Project and Task columns

- One measure to filter the Latest Finish Date filtered by Project and Task columns

The desire outcome should be:

any help will be really appreciated. 

Thanks! 

[vicky_ · Accepted solution]

You can use the allexcept function 

e.g. Early Start = CALCULATE(MIN(Table[Start]), ALLEXCEPT(Table, Table[Project], Table[Task]))