If This Month or This Week falls in Selected Date Ranges

Hi Bird007,

It seems that creating a date dimension would already solve part of the difficulty that you're having here.

But RobJo found a possible solution that might help you out directly. Can you check this out and let us know if it is applicable for you?

http://community.powerbi.com/t5/Desktop/Holiday-Calculation-From-Start-and-End-Date-to-quot-Aggregation/td-p/40507

We discussed this issue in the "Global Power BI - Forum Aid" event.

Come join us at the new Microsoft pbiusergroup.com board for more info, help and fun & informative events

You could try creating the following table which expands the leave date ranges and provides you the ability to count/sum the weekdays

Leave Table = SELECTCOLUMNS(
            FILTER(
                CROSSJOIN('Leave',Dates) ,
                'Leave'[FromDate] <= 'Dates'[Date]
                && 'Leave'[ToDate] >= 'Dates'[Date]
                ),
               "EmployeeID" , [EmployeeID],
               "Absense Type", [AbsenceType] ,
               "From Date" , [FromDate] ,
               "To Date" , [ToDate] ,
               "Date on Leave" , [Date] ,
               "Is Weekday" , SWITCH(
                                WEEKDAY('Dates'[Date],3),
                                --- Saturday ---
                                5,0,
                                --- Sunday ---
                                6,0,
                                --- ELSE ---
                                1
                                )
                             )