topic Re: DAX for subtracting number of days in DAX Commands and Tips

DAX for subtracting number of days

HB2104 — Wed, 27 Sep 2023 01:34:18 GMT

Hello -

Anyone know if there is a DAX formula that can subtract a specific number of working days from a date given? So lets says date is today 9/26/23 and I need to subtract 7 business days from that date which is 9/18/23. Thanks!

Re: DAX for subtracting number of days

nirali_arora — Wed, 27 Sep 2023 07:24:04 GMT

You can use the following dax measure

SubtractWorkingDays = VAR StartDate = TODAY() // Replace with your specific date

VAR NumDaysToSubtract = 7 // Replace with the number of business days to subtract

VAR CalendarTable = CALENDAR(StartDate - NumDaysToSubtract, StartDate)

VAR WorkingDaysTable = FILTER(CalendarTable, WEEKDAY([Date], 2) <= 5)

RETURN MAXX(WorkingDaysTable, [Date])

Re: DAX for subtracting number of days

HB2104 — Wed, 27 Sep 2023 14:56:38 GMT

Do I need to make a working days calendar for this dax? Slightly new at using so trying to understand. Thank you!!

Re: DAX for subtracting number of days

HB2104 — Wed, 27 Sep 2023 16:44:25 GMT

Here is the formula I created but in the subtract working days column it is still giving me the same date rather than prior 7 business days before. Thank you!

Re: DAX for subtracting number of days

HB2104 — Wed, 27 Sep 2023 16:46:47 GMT