Calculated the duration of two date columns, but only the productive days.

[Applicable88]

Hello,

how to create a calculated column like with the datediff(), but instead of counting everyday in between, taken into account that it only counts the "ProductiveDays" ? BookingDate-Incomedate e.g. Datediff( IncomeDate,BookingDate,Day)

BookingTable

IncomeDate		BookingDate		ID
2021-09-01		2021-09-01		8888
2021-09-02		2021-09-03		8889
2021-09-03		2021-09-06		8890
2021-09-06		2021-09-07		8891
2021-09-07		2021-09-07		8892
2021-09-08		2021-09-08		8893
2021-09-09		2021-09-14		8894
2021-09-10		2021-09-13		8895

Mastercalendar

Date	Weekday	ProductiveDay
2021-09-01	Wednesday	1
2021-09-02	Thursday	1
2021-09-03	Friday	1
2021-09-04	Saturday	0
2021-09-05	Sunday	0
2021-09-06	Monday	1
2021-09-07	Tuesday	1
2021-09-08	Wednesday	1
2021-09-09	Thursday	1
2021-09-10	Friday	1
2021-09-11	Saturday	0
2021-09-12	Sunday	0

Thank you very much in advance. 

Best. 

[Fowmy · Accepted solution]

@Applicable88 

I think you have the same question in 3 posts: Find the answer here: https://community.powerbi.com/t5/Power-Query/Networkdays-between-two-dates-dynamically/m-p/2099591

[Applicable88]

Thanks @Fowmy , sorry for posting it also in the PowerQuery group. I wasn't quite sure if a DAX solution would be better or solve this already in PowerQuery. 

Thanks a lot!