- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# Average Number of Days Per Employee

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-22-2018 10:58 AM

Greetings my fellow Power BI ninjas!

I am struggling to create the right syntax/measure that will help me calculate the average number of days for each Dispatch CSR. Below is a screenshot of a small sample of data. Notice how there are multiples for both Tracy + Humberto yet only 1 record for both Stephen + John.

I also created a date table which has working day to correspond with the day in week. The goal is to calculate the average amount of days for each Dispatch CSR (excluding weekends).

Any ideas on how I am able to do this will be much appreciated from you datanaut ninjas

Solved! Go to Solution.

Accepted Solutions

## Re: Average Number of Days Per Employee

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-22-2018 01:11 PM

check if this helps you: https://1drv.ms/u/s!AiiWkkwHZChHjyvMj0kgcbq5urJP

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

**Proud to be a Datanaut!**

All Replies

## Re: Average Number of Days Per Employee

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-22-2018 01:11 PM

check if this helps you: https://1drv.ms/u/s!AiiWkkwHZChHjyvMj0kgcbq5urJP

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

**Proud to be a Datanaut!**

## Re: Average Number of Days Per Employee

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-23-2018 09:32 AM

Absolutely stunning! How on earth did you come up with that syntax? I have been working on this problem for 3 days, never would I have been able to come up with that!!!

Gratitude...thank you!

## Re: Average Number of Days Per Employee

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-23-2018 09:39 AM

Thank you for the feedback!

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

**Proud to be a Datanaut!**

## Re: Average Number of Days Per Employee

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-23-2018 01:19 PM

Question for you...how would you approach this same problem but taking the average days of each CSR as compared to today.

Ex: What is the average amount of days for

- Tracy Marcott 7/25/2014 - Today = 1108

- Tracy Marcott 8/1/2014 - Today = 1103

- Humberto Soistata 8/6/2014 - Today

- etc...

## Re: Average Number of Days Per Employee

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-23-2018 01:43 PM

If I have understood correctly, in the calculated column I have added, instead of my formula, you can input **=TODAY()**

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

**Proud to be a Datanaut!**