cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hayls Frequent Visitor
Frequent Visitor

Adding work days and work hours to a date to determine the "Due by" KPI

Hi,

 

I know this topic has been posted about before, but I can't find the exact calculation that I'm looking for, and I a new user, so appreciate your patience.

 

I have a data set which has a "CASE CREATED" date/time in this format; 30/07/2018 02:02:34 PM

Depending on the Case, there is a KPI of working day or hours i.e. 7 working days, or 1 hour. Ive create a coloumn in the same table called KPI which has these values stored as a duration (i.e. 7.00:00:00 or 0.1:00:00)

 

The end game is to analyse whether the KPI was met. I have the actual dates in a seperate table

Therefore, I was trying to create a coloumn "CASE DUE" which would be the CASE CREATED plus the KPI.

 

I have a seperate Date table created with a WorkDay field (1 = workday and 0 = non = workday).

I just dont know how to add the CASE CREATED to the KPI but consider the work days element.

 

Thanks

I'm just unsure how to add the 

2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: Adding work days and work hours to a date to determine the "Due by" KPI

Hi hayls,

 

Have you built a relationship between table 'CASE CREATED' and another seperate table? Could you post some sample data and clarify more details for further analysis?

 

Regards,

Jimmy Tao

hayls Frequent Visitor
Frequent Visitor

Re: Adding work days and work hours to a date to determine the "Due by" KPI

Here are screen shots of the source tables. There is a relationship between the dates in Power BI

 

Cases.PNGCase tableDates.PNGDates table

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors