cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RitaWK Regular Visitor
Regular Visitor

Get Networking Days in Real time

I need to calculate working days between a start and end day but it must be real time- meaning I have set up reporting periods that have a static start and end day and need to get the real time networking days between that set of days to calculate the current labor cost per employee.   I have a reporting period date table, holiday date table but don't know how to write a real time measure to calculate the networking days - minus weekends and holidays.

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Get Networking Days in Real time

Hi @RitaWK ,

Please check if the similar thread could help you firstly.

If you still need help, please share your data sample and your desired output so that we could help further on it.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
RitaWK Regular Visitor
Regular Visitor

Re: Get Networking Days in Real time

Here is the table for reporting periods.   So I need a dynamic real time calculation of working days.  If am a user looking at my labor costs on April 15th - then I need to get the current working days for Q2 minus weekends.   I haven't set up a massive table by day to do the calculations of day.   I am hoping you can do a calculation like in Excel where based on the current day it will calculate the correct networkings days real-time.   

Doing it by day counting like in the example, how would I keep that table up to date for real-time.  It seems that would only be helpful if dates are in the past not present.

Report Q IDReporting Period NameQuarterYearStart DateEnd Date
1Q1 2019Q1201912/31/20183/29/2019
2Q2 2019Q220194/1/20196/28/2019
3Q3 2019Q320197/1/20199/27/2019
4Q4 2019Q420199/30/201912/27/2019
5Q1 2020Q1202012/30/20193/27/2020

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,621)