Forum Discussion

Daxtothemax's avatar
Daxtothemax
Icon for Helper I rankHelper 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 duration listed or any lower duration. It's hard to explain but I've provided an example of Task ID 2 with the output I'm looking for. Any help is greatly appreciated!

 

 

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

3 Replies

  • 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