Forum Discussion
NETWORKDAYS not available
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)
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.
4 Replies
- ImkeFCommunity Champion
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) - SaraghafelehbasRegular Visitor
I did but It is not in function bar!
- ImkeFCommunity Champion
Yes, you need to upgrade your Power BI version. This function just came out this summer.
- v-henryk-mstfCommunity Support
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.