Calculate next working day based on Holiday column

[sk007]

I want to apply DAX formula to calculate the next_business_day in a Calendar table. 

If the date is holiday (i.e. if_work_day = 0) then next_business_day = date+next working day.

What should be the DAX formula for this? 

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Next_business_day CC = 
MINX (
    FILTER (
        'Calendar',
        'Calendar'[Date] > EARLIER ( 'Calendar'[Date] )
            && 'Calendar'[If_work_day] = 1
    ),
    'Calendar'[Date]
)