Forum Discussion

silkwire's avatar
silkwire
Frequent Visitor
7 years ago
Solved

Determine date value based on several rows

I have a data set that has a random number of rows per request. Each request can have multiple steps.   Each of the steps has a start date and an end date. This is an example of the data:   Re...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    silkwire in dax it is esaier, add following measure

     

    StartDate = 
CALCULATE( MIN( Table6[Task Start] ), ALLEXCEPT( Table6, Table6[Request#] ) )
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

silkwire in dax it is esaier, add following measure

 

StartDate = 
CALCULATE( MIN( Table6[Task Start] ), ALLEXCEPT( Table6, Table6[Request#] ) )