Function NETWORKDAYS not available in DAX

Hi, I'm using PowerBI 2.119.986.0 64-bit (July 2023) in which I try to build a measure using the NETWORKDAYS function. But it looks that it's not available for me. DAX doesn't recognize this formula. Am I doing something wrong?

Need Help

Tips and Tricks

Anonymous
2 years ago
I found the issue. NETWORKDAYS isn't a available function when using a direct link to the database. It's only available when using an import.

6 Replies

Anonymous
Not applicable
2 years ago
I found the issue. NETWORKDAYS isn't a available function when using a direct link to the database. It's only available when using an import.
- vanessafvg
  Community Champion
  2 years ago
  aha! that makes sense, all modelling should be done in the source if you can if you using direct query.
vanessafvg
Community Champion
2 years ago
you need to pass networkdays a set of date values

https://learn.microsoft.com/en-us/dax/networkdays-dax

https://www.mssqltips.com/sqlservertip/7359/calculating-work-days-power-bi-dax-networkdays-function/
- Anonymous
  Not applicable
  2 years ago
  Thanks for your answer. I know the format of the formula. My problem is that DAX doesn't show the formula as one I can use (see my screen print).
  - vanessafvg
    Community Champion
    2 years ago
    can I ask what you doing, are you creating a column, measure, table? you need to give more information

Forum Discussion

Function NETWORKDAYS not available in DAX

6 Replies

Related content

NETWORKDAYS not an available function

NETWORKDAYS not available

Networkdays DAX function

NETWORKDAYS type function in PowerBI

Networkdays with filter function