Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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....
Need Help
Tips and Tricks
  • Anonymous's avatar
    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.

Anonymous's avatar
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's avatar
    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.