Solved: NETWORKDAYS not available

Saraghafelehbas · ‎10-07-2022

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 · ‎10-16-2022

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

After update

Here is the download link:

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.

v-henryk-mstf · ‎10-16-2022

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

After update

Here is the download link:

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 · ‎10-11-2022

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

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Saraghafelehbas · ‎10-11-2022

I did but It is not in function bar!

ImkeF · ‎10-07-2022

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)

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!