Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |