Forum Discussion
Solved
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 abou...
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
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
Community Champion
Community ChampionSciupo 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