Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date difference between two dates in same column

Hi,

 

I need to calculate the date difference between 2 max dates

example below: i need the date difference between Accept and Hired of John

 

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Anonymous,

     

    Or you can use measure below:

    Date Difference = CALCULATE(DATEDIFF(MIN(Table1[Max Date]), MAX(Table1[Max Date]), DAY), ALLEXCEPT(Table1, Table1[Name]))

      

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Johanno's avatar
    Johanno
    Continued Contributor
    7 years ago

    Hi, if you want the difference in number of days you could use as a calculated column:

    Date Difference = 
VAR CurrentPerson = Table1[Name]
VAR AcceptDate = CALCULATE(MAX(Table1[Max date]);FILTER(Table1;Table1[Name]=CurrentPerson);Table1[Step]="Accept")
VAR HiredDate = CALCULATE(MAX(Table1[Max date]);FILTER(Table1;Table1[Name]=CurrentPerson);Table1[Step]="Hired")
RETURN HiredDate-AcceptDate

     

     

    /Johan

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous,

     

    Or you can use measure below:

    Date Difference = CALCULATE(DATEDIFF(MIN(Table1[Max Date]), MAX(Table1[Max Date]), DAY), ALLEXCEPT(Table1, Table1[Name]))

      

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.