Count working days excluding Bank holidays

[jak8282]

Hi,

I have a Calendar table  and a complaints table.  I am wanting to work out the days between when workday is 1 and bank holiday is 0 - how can I do this - tried a few things but cant seem to get it to work

example

Date	Is Workday	Bank Holiday
25/02/2024	1	0
26/02/2024	1	0
27/02/2024	0	1

I also have a complaints table

Date Raised	Initial Response
25/02/2024	28/02/2024

[jak8282]

Thanks @amitchandak that looks good - i managed to get it working by using

BusinessDaysCount = 
    VAR originalDate = 'Complaints'[Original Date of Complaint]
    VAR closedDate = 'Complaints'[Initial closed date]
    RETURN
    CALCULATE(
        COUNT('Calendar Date'[date]),
        FILTER(
            ALL('Calendar Date'),
            'Calendar Date'[date] >= originalDate &&
            'Calendar Date'[date] <= closedDate &&
            'Calendar Date'[Bank Holidays] = 0 &&
            'Calendar Date'[Is Weekday] = 1
        )
    )-1

[DataNinja777]

Hi @jak8282 ,

You can use Networkdays function like below:

Best regards,

[amitchandak · Accepted solution]

@jak8282 , You can use networkdays, you can also pass holiday list as table to this function

networkdays([Start Date], [End Date], 1)

refer how to use calendar for holiday

Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
https://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c