Dynamic Day calculation based on weekly

Here is one way, which basically involves expanding the from / to dates.

Create a new table using:

 

Expanded =
VAR _EXP =
    GENERATE (
        'Original Table',
        CALENDAR ( 'Original Table'[From date ], 'Original Table'[To Date] )
    )
RETURN
    SELECTCOLUMNS (
        _EXP,
        "_Employee Num", 'Original Table'[Employee Number],
        "_App on", 'Original Table'[Applied on ],
        "_Dates", [Date]
    )

 

 

Create a Calendar Table and a dimension table for employees using:

 

Calendar Table =
ADDCOLUMNS (
    CALENDAR ( MIN ( Expanded[_Dates] ), MAX ( Expanded[_Dates] ) ),
    "MonthNum", MONTH ( [Date] ),
    "Month", FORMAT ( [Date], "MMM" ),
    "Year", YEAR ( [Date] ),
    "WeekNum", WEEKNUM ( [Date] ),
    "W #", "W" & WEEKNUM ( [Date] )
)

 

Employee Table = 
DISTINCT('Original Table'[Employee Number])

 

 Create single direction one-to-many relationships between these new tables and the corresponding fields in the "Expanded" table. The model looks like this:

Next create the following measure:

 

WFH Dates = 
COUNT(Expanded[_Dates])

 

Create a table visual with 'Employee Table'[Employee] and the measure to get:

 Create a new table visual with the 'Employee Table'[Employee] and 'Calendar Table'[Date] (rename the latter to whatever you wish) to get

 Create a matrix visual with 'Employee Table'[Employee] as rows, 'Calendar Table'[W#) as columns and the [WFH Dates] measure to get:

 

 

Attached is the sample PBIX file

Hi Anonymous 
Please refer to attached sample file with the solution

Mumber of Days = 
VAR MinDate =
    MIN ( 'Date'[Date] )
VAR MaxDate =
    MAX ( 'Date'[Date] )
VAR Dates1 =
    CALENDAR ( MinDate, MaxDate )
RETURN
    SUMX (
        'Table',
        VAR Dates2 =
            CALENDAR ( 'Table'[From Date], 'Table'[To Date] )
        RETURN
            COUNTROWS ( FILTER ( INTERSECT ( Dates1, Dates2 ), NOT ( WEEKDAY ( [Date], 2 ) IN { 6, 7 } ) ) )
    )

To manage holidays, you will need to import a table listing public holidays. In this example I imported public holidays for the UK from the Uk-gov website.

 You can then use a measure to subtract WFU days which occur on a holiday as follows:

Non Hols WFH = 
VAR _NWD = CALCULATE(COUNT(Expanded[_Dates]), FILTER('Calendar Table', 'Calendar Table'[Date] IN VALUES('Holiday Table'[Date])))
RETURN
COUNT(Expanded[_Dates]) - _NWD

 Or you can include the holidays in a new column in the calendar table

 And use this measure to exclude holidays:

WFH non hol Days (Calendar) =
CALCULATE (
    COUNT ( Expanded[_Dates] ),
    FILTER ( 'Calendar Table', ISBLANK ( 'Calendar Table'[Holiday] ) )
)

 

New file attached