Power BI

New

NETWORKDAYS DAX /Power Query formula

Vote (87)

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 (24)

Andreu fil on 19 Apr 2024 12:37:27

RE: NETWORKDAYS DAX /Power Query formula

Good information, thankssehackear.top

Marian Szetyinszki on 06 Sep 2022 09:04:21

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.

on 15 Jul 2022 22:54:25

RE: NETWORKDAYS DAX /Power Query formula

@Microsoft team : This query raised in 2015.. Still not implemented in any version updates.. Pls incorporate networkdays formula in powerBi..

on 15 Jul 2022 22:54:25

RE: NETWORKDAYS DAX /Power Query formula

It would be great if power bi would have a funtion that could hep the user calculate the working days between two days. There are workarounds, would be great if there was a simple dax function for it

Milos Husarcik on 17 Sep 2021 09:14:33

RE: NETWORKDAYS DAX /Power Query formula

we need this calculation

Frantisek Voros on 16 Sep 2021 08:38:25

RE: NETWORKDAYS DAX /Power Query formula

This definitely needs to be a valid calculation.

Guannan Ye on 16 Sep 2021 02:52:24

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

Ronald Anderson on 15 Sep 2021 13:13:48

RE: NETWORKDAYS DAX /Power Query formula

This definitely needs to be a valid calculation.

Yuan Tian on 15 Sep 2021 07:15:38

RE: NETWORKDAYS DAX /Power Query formula

Fully agree, it really needful for our daily work and operation.

Ruiye Lu on 14 Sep 2021 16:39:58

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.

Merged Idea (4)