Calculate the number of business days between two dates in power pivot

Question

How can I set business days on two dates 

And I am using the following query

DATEDIFF(dd, Date1, GETDATE()) - (DATEDIFF(wk, Date1, GETDATE()) * 2) -
            CASE WHEN DATEPART(dw, Date1) = 1 THEN 1 ELSE 0 END +
            CASE WHEN DATEPART(dw, GETDATE()) = 1 THEN 1 ELSE 0 END END 

How can I do that?

Answer 1

To do that use the measure

=SWITCH(WEEKDAY([CalendarDate]),7,FALSE(),1,FALSE(),TRUE())

Intellipaat provides a complete Course on Power BI, Enroll now.