Calculate number of days between 2 dates without weekends

[edram]

I need to calculate the number of days between 2 different dates excluding the weekends.

Currently I'm doing manualy on Excel with the function Networkdays but the ideal is to be implemented on Power BI as new colum. Any idea how it can be done?

[v-sihou-msft · Accepted solution]

@edram

To calculate the net workdays, I suggest you add a calculated column in your date table.

IfWorkDay = SWITCH(
WEEKDAY('Table'[Date],2),
6,0,
7,0,
1)

Then you can calculate the net work days based on above column.

[Net WorkDays]= CALCULATE(SUM('Table'[IfWorkDay]),DATESBETWEEN('Table',<start_date>,<end_date>))

Regards,

[msg0505]

FOR

IfWorkDay = SWITCH(
WEEKDAY('Table'[Date],2),
6,0,
7,0,
1)

Is the Variable DATE the from date or to date in my table to calculate the difference? Sorry new to PowerBI 

[parry2k]

Ddi you looked at this post on the forum:

http://community.powerbi.com/t5/Desktop/Networkdays-DAX-function/m-p/38597

Thanks,

P