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

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi, I'm trying to build a measure.