Forum Discussion

ConnorH's avatar
ConnorH
Microsoft Employee
6 years ago
Solved

Finding days between two rows date values

This is kind of complex and I haven't been able to figure it out. I am trying to create a column that finds the number of days between a project status but the project ID must be the same. The projec...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi ConnorH ,

     

    Create a Calculated Column

     

    Column =
VAR _prevstage_sameprojId_date =
    CALCULATE (
        MAX ( 'Table1'[Modified date] ),
        FILTER (
            'Table1',
            'Table1'[Modified date]
                < EARLIER ( 'Table1'[Modified date] )
                && Table1[Project ID]
                    = EARLIER ( Table1[Project ID] )
        )
    )
RETURN
    DATEDIFF (
        _prevstage_sameprojId_date,
        'Table1'[Modified date],
        DAY
    )

     

    Regards,
    Harsh Nathani

    Appreciate with a Kudos!! (Click the Thumbs Up Button)
    Did I answer your question? Mark my post as a solution!

amitchandak's avatar
amitchandak
Super User
6 years ago

ConnorH , Try a new column like

datediff(Table[Date], minx(filter(Table,Table[Date] <earlier(Table[Date])) ,Table[Date]),day)