Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

mszetyinszki

NETWORKDAYS DAX /Power Query formula

Submitted by on ‎04-09-2021 04:19 AM
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 .
Status: New
See more ideas labeled with:
24 Comments (24 New)
Comments
nishalit
New Member
‎07-15-2022 03:54 PM
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
nishalit
New Member
‎07-15-2022 03:54 PM
@Microsoft team : This query raised in 2015.. Still not implemented in any version updates.. Pls incorporate networkdays formula in powerBi..
mszetyinszki
New Member
‎09-06-2022 02:04 AM

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.

fbcideas_migusr
New Member
‎02-25-2025 12:37 AM
Status changed to: New