Difference between two dates with excluding weekends.

Hi Anonymous ,

Assum that there is one date dimension table in your model, you can create a calculated column as below to get the number of days between two dates. Please find the details in the attachment.

No.of Days =
VAR _enddate =
    IF ( ISBLANK ( 'Table'[End Date] ), TODAY (), 'Table'[End Date] )
RETURN
    CALCULATE (
        COUNTROWS ( 'Date' ),
        DATESBETWEEN ( 'Date'[Date], 'Table'[Start Date], _enddate ),
        FILTER ( 'Date', WEEKDAY ( 'Date'[Date], 2 ) < 6 )
    )

In addition, you can refer the following blog to get it by DAX or Power Query method...

Calculate Workdays Between Two Dates In Power BI

Best Regards