Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Using ALLSELECTED and ALLEXCEPT Together to Get Max Date at Higher Level

Hi all,   This seems like a pretty basic challenge I have. And it's driving me nuts that I can't figure it out.   Sample dataset:           I want to return the Max Date at the Project lev...
ALLEXCEPT
ALLSELECTED
  • Anonymous's avatar
    Anonymous
    4 years ago

    My colleague was able to solve

     

    Project Max Date (working) = CALCULATE(MAX(Sheet1[Date]),

    FILTER(AllSELECTED(Sheet1), Sheet1[Project #] = SELECTEDVALUE(Sheet1[Project #])))
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Use MAX ( Sheet1[Date] )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Also this might work
MAXX ( ALLSELECTED ( Sheet1[Job #] ), CALCULATE ( VALUES ( Sheet1[Date] ) ) ),

ALLSELECTED ( Sheet1[Project #] )

)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I haven't tried your last one. But wanted to message that my colleuge was able to solve.

     

    Project Max Date (working) = CALCULATE(MAX(Sheet1[Date]),

    FILTER(AllSELECTED(Sheet1), Sheet1[Project #] = SELECTEDVALUE(Sheet1[Project #])))