Help with DAX - adding working days to a date

[Anonymous]

I'm learing DAX and can't get my head around how to add 10 workings days to a given date.

We have a date table that has (FullDate, IsWorkingDay).

So I want a DAX formula that does something like the below.

Any assistance apprfeciated!

DatePlus10WorkingDays :=

VAR StartDate = DATE(2020,1,1)

VAR StartDatePlus10WD = 

SELECT MAX (

SELECT TOP (10) Date[FullDate]

FROM Date

WHERE Date[FullDate] > StartDate

AND Date[IsWorkingDay] = "Y"

ORDER BY Date[FullDate]

))

RETURN StartDatePlus10WD 

[Greg_Deckler]

I've done some working days stuff: https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/td-p/367362

Perhaps create a table VAR of your starting date plus 15 days so, VAR __Calendar = CALENDAR([Date],[Date]+15). Then use ADDCOLUMNS to add my net work days column to calculate the number of work days between the date in each calendar row and your date. Filter to the one that is 10.