Forum Discussion
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
Hi Anonymous ,
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
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
