Marian Szetyinszki on 2021-04-09 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)
Diana Dumitrache on 2021-07-01 08:21:27
Networkdays equivalent
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
Conrad Wong on 2015-04-24 01:40:13
Siddique T L on 2021-12-03 12:09:37
NETWORKDAYS DAX in powerBi
@Microsoft team : This query raised in 2015.. Still not implemented in any version updates.. Pls incorporate networkdays formula in powerBi..
Marcus Vinicius Pereira Lima on 2018-04-26 02:32:28
Implement workday.intl and NETWORKDAYS.INTL formulas in DAX
Implement workday.intl and NETWORKDAYS.INTL formulas in DAX. It is too hard to make working days calculations without these Excel formulas.