Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need help with a DAX

Hello All,

 

I'm stuck with a query to find the date difference in my data set.

 

Emp NameProcessCreated DateCompleted Date
Emp 1Hire1/1/20231/2/2023
Emp1Contract1/5/20231/6/2023

 

I need to calculate the difference between the created and completed date (highlighted in bold), but I'm unable to get the dax for the same. Can anyone help me write this out?

Thanks for the help in advance!!

Need Help
  • Igna's avatar
    Igna
    2 years ago

    Hello,

     

    You could try to calculate the difference between the minimum created date and the maximum completed date for a Emp :

     

    Date Difference = 
VAR MinCreateDate = CALCULATE(MIN('YourTable'[Created Date]), ALLEXCEPT('YourTable', 'YourTable'[EmpName]))
VAR MaxCompletedDate = CALCULATE(MAX('YourTable'[Completed Date]), ALLEXCEPT('YourTable', 'YourTable'[EmpName]))
RETURN MaxCompletedDate - MinCreateDate

     

     

    Tell me if this works 🙂

     

    Igna

4 Replies

  • Igna's avatar
    Igna
    Resolver III
    2 years ago

    Hello,

     

    You could try to calculate the difference between the minimum created date and the maximum completed date for a Emp :

     

    Date Difference = 
VAR MinCreateDate = CALCULATE(MIN('YourTable'[Created Date]), ALLEXCEPT('YourTable', 'YourTable'[EmpName]))
VAR MaxCompletedDate = CALCULATE(MAX('YourTable'[Completed Date]), ALLEXCEPT('YourTable', 'YourTable'[EmpName]))
RETURN MaxCompletedDate - MinCreateDate

     

     

    Tell me if this works 🙂

     

    Igna

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago

    Create a column using datediff function.

    Ex. 

    datediff = DATEDIFF(q2[Created Date], q2[Completed Date], DAY)
     
    **q2 is table name.
    • Igna's avatar
      Igna
      Resolver III
      2 years ago

      This will not work as the two dates are not in the same row