topic Re: Calculated the duration of two date columns, but only the productive days. in DAX Commands and Tips

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

Applicable88 — Mon, 27 Sep 2021 08:01:21 GMT

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.

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

Fowmy — Mon, 27 Sep 2021 08:07:53 GMT

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

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

Applicable88 — Mon, 27 Sep 2021 08:11:08 GMT

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!