Forum Discussion

Truecharv's avatar
Truecharv
New Member
3 years ago
Solved

Date Calculation between three dates

My data set has a creation date, reopend date, and closed date column. Not all lines have a reopen date. I am trying to create a column that will calculate the age based on the reopend date if it has...
  • Truecharv's avatar
    Truecharv
    3 years ago

    This formula did not quite work but it was a great help to start testing. I was able to get the code to work with the following:

     

    Age =

    IF( 

    [Reopen] <> BLANK (),

    [Closed date]-[Reopen date],

    [Closed date]-[created date])

Nathaniel_C's avatar
Nathaniel_C
Community Champion
3 years ago

Hi Truecharv ,

If you wish a measure, try this:

Duration =
IF (
    ISBLANK ( MAX ( dtaTable[Reopen Date] ) ),
    DATEDIFF ( MAX ( dtaTable[Creation Date] ), MAX ( dtaTable[Closed Date] ), DAY ),
    DATEDIFF ( MAX ( dtaTable[Reopen Date] ), MAX ( dtaTable[Closed Date] ), DAY )
)

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    3 years ago

    Hi Truecharv ,
    Here is what my table looks like:


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel