Does Excel Data Model Not Have DAX function for NETWORKDAYS?

[Txtcher]

I have a table loaded into the data model in Excel. I can't find the function for NETWORKDAYS. 

I tried to google this question and could not find an answer.

[anilelmastasi · Accepted solution]

Hello @Txtcher ,

NETWORKDAYS is an Excel worksheet function, not a DAX function. In Power Pivot or Power BI, you’ll need to use DAX to replicate that functionality.

Firstly you need a calendar table. You can refer this blog:

https://community.fabric.microsoft.com/t5/Desktop/using-the-Calendar-function-and-power-query/td-p/3...

How to replicate NETWORKDAYS in DAX?

You can create an calculated column with:

IsWorkday = IF(WEEKDAY(DateTable[Date], 2) <= 5, 1, 0)

If this solved your issue, please mark it as the accepted solution. ✅