Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help with DAX - adding working days to a date

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