Forum Discussion

JSIQUEI-YYC-ENB's avatar
JSIQUEI-YYC-ENB
Icon for Helper I rankHelper I
3 years ago
Solved

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

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! 

Need Help
  • vicky_'s avatar
    vicky_
    3 years ago

    You can use the allexcept function 

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

     

1 Reply

  • vicky_'s avatar
    vicky_
    Icon for Super User rankSuper User
    3 years ago

    You can use the allexcept function 

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