Add Column: Calculate Business Days Between 2 dates in the same table

[AW1976NOVA]

Hi,

I have a table that I need to add a column to the will return the number of business days between 2 days.  Here is an example of the data.

Claim Number       Date Received     Date Adjudicated

0001                       1/1/2022             1/5/2022

2323                       2/5/2022             2/6/2022

7676                       3/1/2022             3/10/2022

I do not require a Calendar Table in this situation.  I just need the numerical value of the business days returned for each row of data in the table.

Thank you

[v-henryk-mstf]

Hi @AW1976NOVA ,

Thanks for your reply. If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,
Henry

[AW1976NOVA · Accepted solution]

Days Between WD = COUNTROWS ( FILTER ( ADDCOLUMNS ( CALENDAR ( 'Claim_Data_Append'[Received Date], 'Claim_Data_Append'[Adjudicated_Date] ), "Day of Week", WEEKDAY ( [Date], 2 ) ), [Day of Week] <> 6 && [Day of Week] <> 7 ) )

Got this to work for me

[Samarth_18]

Hi @AW1976NOVA ,

Please try this:-

business_day = 
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            CALENDAR (
                [Date Received],
                [Date Adjudicated]
            ),
            "Day of Week", WEEKDAY ( [Date], 2 )
        ),
        [Day of Week] <> 6
            && [Day of Week] <> 7
    )
)

I have considered Saturday and Sunday as holiday in my calculation.

Thanks,

Samarth