Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Average Number of Days Per Employee

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 

 

AvgDaysCSR.png

 

WorkingDayDayInWeek.png

1 ACCEPTED SOLUTION
LivioLanzo
Solution Sage
Solution Sage

@Anonymous

 

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

 

Capture.PNG

 


 


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


Proud to be a Datanaut!  

View solution in original post

5 REPLIES 5
LivioLanzo
Solution Sage
Solution Sage

@Anonymous

 

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

 

Capture.PNG

 


 


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


Proud to be a Datanaut!  

Anonymous
Not applicable

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! 

Thank you for the feedback! 

 


 


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


Proud to be a Datanaut!  

Anonymous
Not applicable

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

 

 

 

 AvgDaysCSR.png

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 correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

Helpful resources

Announcements
Europe Fabric Conference

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.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.