How to calculate net working days - Step by Step

[Sciupo]

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

[Sathiyavigraman]

@vanessafvg 

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.

[vanessafvg]

@Sciupo

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?

[Sciupo]

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 · Accepted 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

[Sciupo]

@vanessafvg it seems to be what I am looking for. I am giving a go!

Thanks

Marco