Forum Discussion
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
1 Reply
- Greg_Deckler
Community Champion
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.