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 th...
Greg_Deckler
Community Champion
Community ChampionI'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.