NETWORKDAYS not available

[Saraghafelehbas]

Hi,

I do not have access to NETWORKDAYS in power BI. Any one can help me with that?

here is my version: 2.105.923.0 64-bit (May, 2022)

[v-henryk-mstf · Accepted solution]

Hi @Saraghafelehbas ,

Try updating your powerbi desktop to the latest version to use this function properly.

After update

Here is the download link:

Download Microsoft Power BI Desktop from Official Microsoft Download Center

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ImkeF]

Yes, you need to upgrade your Power BI version. This function just came out this summer.

[Saraghafelehbas]

I did but It is not in function bar!

[ImkeF]

Hi @Saraghafelehbas ,
make sure that you are searching in the DAX-editor for that function.
If you want to use it in the query editor (Transform data), then you can copy this custom function for it:
Date.Networkdays function for Power Query and Power BI – (thebiccountant.com)