Showing results for 
Search instead for 
Did you mean: 
A_Ch Visitor

Calculate Days in Role/Project

Hi All,


I was in need of some help in calculating the number of days between events. I am trying to calculate how long employees were in certain roles or on certain projects. Below is how my data table is modeled.


DateEmployee IDRole/ProjectEventDays Employed
1/1/201801New HireNew Hire1
1/2/201801New Hire 2
1/3/201801New Hire 3
1/4/201801Intern 4
1/5/201801Intern 5
1/6/201801Intern 6
1/7/201801Intern 7
1/8/201801Level 1Role Change8
1/9/201801Level 1 9
1/10/201801Level 1 10
1/11/201801Level 1 11
1/12/201801Level 1 12
1/13/201801Level 1 13
1/14/201801Level 1 14
1/15/201801Level 2Role Change15
1/16/201801Level 2 16
1/17/201801Level 2 17


In my model, New Hire and Intern are considered as the same position essentially.

Any help is greatly appreciated.

Super User
Super User

Re: Calculate Days in Role/Project

I'm guessing a column and use of EARLIER. See my article on Mean Time Before Failure (MTBF) which uses EARLIER:

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Community Support Team
Community Support Team

Re: Calculate Days in Role/Project

Hi @A_Ch


You may refer to below dax to create calculated columns.

Role/Project 2 =
IF ( Table3[Role/Project] = "Intern", "New Hire", Table3[Role/Project] )


Long =
    FILTER ( Table3, Table3[Role/Project 2] = EARLIER ( Table3[Role/Project 2] ) )






Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.