Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
albrighm
Regular Visitor

Networkdays not recognized

‎08-18-2022 07:29 AM

In July 2022 the =Networkdays dax equation was released. I am currently attempting to use this equation and Power Query is not recognizing it as a supported or valid equation. Our products are all managed through our Organization. Another associate is able to use this equation, same network and same version of Power BI. Any insight as to why my PowerBI version would not accept Networkdays as valid?

Labels:
Message 1 of 2
961 Views
0
1 REPLY 1
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

‎08-18-2022 10:58 AM

Hi @albrighm - the NETWORKDAYS function is a DAX function which is used within the Data Model.  Power Query is different language that is used to create the Data Model.  There is no equivalent Date.NetWorkdays Power Query function.  Some users have created their own function for Power Query. 

Message 2 of 2
912 Views
0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

View All