Forum Discussion
How to calculate net working days - Step by Step
Dear All,
I am quite new with Power BI and I would need your support.
What I am trying to do is to calculate the net working days between two dates. I know that there are plenty of posts about this topic, however, I would need a step by step guide on how to do it.
In addition, would be possible to do this already in the Edit Queries part instead of building a new column or measure in the Desktop view.
Thanks for your help.
Marco
Sciupo a little busy now so can't help with step by step but does this link help at all? seems to give the step by step.
https://www.powerquery.training/portfolio/networkdays/
feel free to tag me for questions if you need clarification
5 Replies
- vanessafvg
Community Champion
you can probably find a lot of the detail here
https://msdn.microsoft.com/en-us/library/mt296613.aspx?f=255&MSPPError=-2147217396
can you post a screenshot of your data the columns you want a date diff between and what is the interval?
for net working days, do you have a date table,
what is a working day? (working days vary from country to country), d
o you a way of flaggign a working day?
Hi vanessafvg,
The Net Working days should be the difference between Sales Order date and Creation date.
This will exclude all the Saturdays and Sundays from the calculation (i.e same as in excel with the =NETWORKDAYS function).
Thanks
Marco
- vanessafvg
Sciupo a little busy now so can't help with step by step but does this link help at all? seems to give the step by step.
https://www.powerquery.training/portfolio/networkdays/
feel free to tag me for questions if you need clarification
Since i dont have a account in skillwave, I couldn't see your reply. Please share here, if you busy share as screenshot would work.
