calculate working days between two dates in row

[cottrera]

Firstly appologies I am really new to power bi. I need to calculate the working days between two date in row.  I have tried using DATEDIFF which works for calendar days but I wish to exclude weekwends

Example

DataDump[Date Logged] and DataDump[Date Completed]

I have a second dates table that contains a field called 'SHARED Calendar'[is_weekend] which diplays 1 for saturday and sunday and 0 for weekdays.

I wish to know if DATEDIFF to calculate working days.

Richard

[Zubair_Muhammad · Accepted solution]

@cottrera 

Please check if this article helps

http://www.excelnaccess.com/count-only-working-days-between-2-dates/

Count Business Days =
VAR MyDates =
 ADDCOLUMNS (
 GENERATESERIES ( TableName[StartDate] + 1, TableName[ EndDate] ),
 "Day", WEEKDAY ( [Value], 2 )
 )
RETURN
 COUNTROWS ( FILTER ( mydates, [Day] <= 5 ) )

[cottrera]

Perfect thank you