Adding x working days to a input date

[DennisSchlein]

Hi 

I have a calculated column where I want to add X working days to my imut date.

Basicly its like:

Input Date:     BaseData[EventTime (CMR_Close)] - ex.: 01-11-2023
Adder:     BaseData[Report WorkDays] - Ex.: 3

Expected Result: 06-11-2023 (Since day 3 is saturday)

How do I change the bold text to be workdays in stead?

Report Ready Date =

    BaseData[EventTime (CMR_Close)] +

    BaseData[Report WorkDays] +

    COUNTX(

        FILTER(

            Holidays,

            Holidays[COUNTRYCODE] = BaseData[recipient_country_code] &&

            Holidays[HolidayDate] >= BaseData[EventTime (CMR_Close)] &&

            Holidays[HolidayDate] <= BaseData[EventTime (Transit)] &&

            WEEKDAY(Holidays[HolidayDate] - 1) < 6

        ),

        Holidays[COUNTRYCODE]

    )

[DennisSchlein]

Hi @Anonymous 

I will create one 🙂 

I have this piece of code that is not giving errors, but not the expected result:

TEST 2 = 
VAR CurrentDate = TODAY()
VAR NextWorkingDates = 
    FILTER( 
        ALL( DateTable[Date] ),
        DateTable[Date] > CurrentDate && RELATED(DateTable[Working Day]) = TRUE()
    )

VAR Next10WorkingDays = TOPN( 11, NextWorkingDates, 'DateTable'[Date], ASC )
VAR Result = MAXX(Next10WorkingDays, 'DateTable'[Date])
RETURN Result

This is diffently not what I expected to get.

Basicly I want to have an input data - expected project workdays - and then expected ready date.

Let me know if I make no sense 🙂

I Created a sample here:
https://www.transfernow.net/dl/20240216cAtDviKK

[Anonymous]

Hi, @DennisSchlein 

Can you provide some sample data or PBIX files?

And don't give out private information and personal information.

Best Regards

Yongkang Hua