Need help with a DAX

[Anonymous]

Hello All,

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

Emp Name	Process	Created Date	Completed Date
Emp 1	Hire	1/1/2023	1/2/2023
Emp1	Contract	1/5/2023	1/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!!

[ChiragGarg2512]

Oh, ok

[Igna · Accepted solution]

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]

Create a column using datediff function.

Ex. 

datediff = DATEDIFF(q2[Created Date], q2[Completed Date], DAY)

**q2 is table name.

[Igna]

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