cancel
Showing results for
Did you mean:
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

## Re: Get Networking Days in Real time

Hi @RitaWK ,

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.
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 ID Reporting Period Name Quarter Year Start Date End Date 1 Q1 2019 Q1 2019 12/31/2018 3/29/2019 2 Q2 2019 Q2 2019 4/1/2019 6/28/2019 3 Q3 2019 Q3 2019 7/1/2019 9/27/2019 4 Q4 2019 Q4 2019 9/30/2019 12/27/2019 5 Q1 2020 Q1 2020 12/30/2019 3/27/2020

Announcements

#### New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

#### November 2019 Community Highlights

Get an overview of the events and great community content from November.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)