Forum Discussion
Calculating working days
v-robertq-msft , I think I've found it!
The date table and workingday column are the samen, but the working days delta has become the following:
as you can see, the one delayed shipment in the overview now gets a positive number. I should be able to use this to measure delayed shipments within a tolerance finally get the performance based on working days! :):):)
Hi, PaulusD
According to your description and sample pictures, I can’ figure out what’s the logic of your calculated column [WorkDaysCounter], why it has navigated numbers? Would you like to explain it in detail?
What’s more, I think it’s better if you can upload the test pbix file without sensitive data or some sample data so that we can help you in advance.
How to Get Your Question Answered Quickly
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-robertq-msft ,
The idea is that we're measuring the count of workdays between two dates. Based on this we can measure if a shipment was delivered within contractual leadtime.
I'm fairly confident that the approach that i've taken is in line with best practices for this (based on info found in the community and the web).
If I can get this working, we could incorporate the national holidays and end up with a true nett measurement in terms of performance.
I treid two approaches.
One where a return a value of 1 (for workdays) and a 0 for weekends. In the calculate I count the total results betweendates.
The second is I check if the date is a workingday, returning true for workdays and false for weekends. In the calculate I used countrows filtering on true values.
neither of these provide the results I see others generating and I just cant figure out where i'm going wrong 😞