Marian Szetyinszki on 09 Apr 2021 11:19:56
Enable an engine built in formula to calculate Excel equivalent of networking days: Number of business days between 2 dates, excluding weekends and bank holidays provided as an optional list of dates.
Currently only complex solutions using other DAX / Query formulas can be used , this solution is very slow and memory intense when applied across many rows and Country holidays table in a multi country regions .
- Comments (23)
- Merged Idea (4)
RE: NETWORKDAYS DAX /Power Query formula
Thanks for all the votes and the team effort to implement the function! I can see people screaming with happiness when I say this news.
RE: NETWORKDAYS DAX /Power Query formula
we need this calculation
RE: NETWORKDAYS DAX /Power Query formula
This definitely needs to be a valid calculation.
RE: NETWORKDAYS DAX /Power Query formula
This feature definitely can help our analysis on ECT or Turn Around Time, and this is common issue our vendor raise to us specially when we set TAT target to measure vendor performance. Just a reminder this net workday should be states/city specific, like Australia, different state has different holiday, or same holiday name but different states set on different date
RE: NETWORKDAYS DAX /Power Query formula
This definitely needs to be a valid calculation.
RE: NETWORKDAYS DAX /Power Query formula
Fully agree, it really needful for our daily work and operation.
RE: NETWORKDAYS DAX /Power Query formula
Fully agree! Now each company is using non-standard holiday tables to come out with net work days. If Microsoft provided a global standard solution in Power BI, it will be a very convincing function to utilize Power BI more.