cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.
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 Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

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

November 2019 Community Highlights

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

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)