Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@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
Proud to be a Super User!
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.
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?
Proud to be a Super User!
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
@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
Proud to be a Super User!