Adding business days to a date and get date

[Hems]

Need to add business days to date and get new date column. Above is the example for the output.

[Anonymous · Accepted solution]

Hi @Hems ,

I suggest you to create a calendar table to help you achieve your goal.

My Sample:

Calendar:

Calendar = 
ADDCOLUMNS (
    CALENDARAUTO (),
    "Year", YEAR ( [Date] ),
    "Month", MONTH ( [Date] ),
    "WeekDay", WEEKDAY ( [Date], 2 ),
    "Flag",
        VAR _WEEKDAY =
            WEEKDAY ( [Date], 2 )
        RETURN
            IF (
                [Date] IN VALUES ( Holidays[Holidays] ),
                "Holiday",
                IF ( _WEEKDAY IN { 6, 7 }, "Weekend", "Business Day" )
            )
)

Add a calcualted column in calendar table.

Rank = RANKX(FILTER('Calendar','Calendar'[Flag] = "Business Day"),[Date],,ASC)

Then add a calculated column in your table.

Need Output = 
CALCULATE (
    MAX ( 'Calendar'[Date] ),
    FILTER (
        'Calendar',
        'Calendar'[Flag] = "Business Day"
            && 'Calendar'[Rank]
                = RELATED ( 'Calendar'[Rank] ) + 'Table'[SLA]
    )
)

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.