Showing results for 
Search instead for 
Did you mean: 
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.


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,



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

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)