Forum Discussion

Daxtothemax's avatar
Daxtothemax
Helper I
4 years ago
Solved

Remaining Duration Based off Original

Hi All,   I'm really struggling with this. Users are updating duration greater than the original value. I'm looking for a DAX formula to capture the remaining duration based off the original durati...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Daxtothemax ,

     

    Please check the formula.

    Column =
CALCULATE (
    MIN ( 'Table'[Remaining Duration] ),
    FILTER (
        'Table',
        'Table'[Task ID] = EARLIER ( 'Table'[Task ID] )
            && 'Table'[Date] <= EARLIER ( 'Table'[Date] )
    )
)

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Daxtothemax ,

 

Please check the formula.

Column =
CALCULATE (
    MIN ( 'Table'[Remaining Duration] ),
    FILTER (
        'Table',
        'Table'[Task ID] = EARLIER ( 'Table'[Task ID] )
            && 'Table'[Date] <= EARLIER ( 'Table'[Date] )
    )
)

 

Best Regards,

Jay

Daxtothemax's avatar
Daxtothemax
Helper I
4 years ago

Perfect, thank you Anonymous