cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
A_Ch Visitor
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.

2 REPLIES 2
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: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...


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

Proud to be a Datanaut!


Highlighted
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 =
COUNTROWS (
    FILTER ( Table3, Table3[Role/Project 2] = EARLIER ( Table3[Role/Project 2] ) )
)

1.png

 

Regards,

Cherie

 

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.