cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## Need help with a DAX

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!!

1 ACCEPTED SOLUTION
Resolver III

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 4
Super User

Oh, ok

Resolver III

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

Super User

Create a column using datediff function.

Ex.

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

**q2 is table name.
Resolver III

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.