Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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?
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.
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 12 | |
| 6 | |
| 5 | |
| 5 | |
| 5 |