How do I get working days between dates in Power BI?

Question

I am calculating a measure between two dates by using the formula

TAT = CALCULATE(SUM('Days Table'[Is Work Day]),
DATESBETWEEN('Days Table'[Date],'Re-run Data'[DATE_ORDERED],'Re-run 
Data'[DATE_COMPLETED]))

I am not getting a proper result,Is there any way to solve this? 

Answer 1

Use the following measures

TAT = 
    COUNTROWS ( 
        FILTER ( 
            ADDCOLUMNS(
                DATESBETWEEN ( 
                    'Calendar'[Date],
                    MIN ( 'Re-run Data'[DATE_ORDERED] ),
                    MAX ( 'Re-run Data'[DATE_COMPLETED] )
                ),
                "Is Weekday", WEEKDAY ( 'Calendar'[Date], 2) < 6,
                "Is Holiday", CONTAINS ( Holidays, Holidays[Holiday Dates], 'Calendar'[Date] )
            ),
            [Is Weekday] = TRUE() && [Is Holiday] = FALSE()
        )
    )

 Want to learn more about Power BI? Register now: Power Bi Course