Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |