topic Re: Days Between Dates with Negatives in DAX Commands and Tips

Days Between Dates with Negatives

Greg_Deckler — Sat, 13 Aug 2016 02:07:50 GMT

Have used this one countless times. The problem is that DAYSBETWEEN DAX function does not allow returning negative values, so instead use:

DaysBetween = ROUNDUP(1.*[Date]-[OtherDate],0),

Phil_Seamark — Wed, 17 Aug 2016 00:34:06 GMT

Here is an ugly alternative :)

Column = IFERROR(
DATEDIFF(Dates[Date],Dates[OtherDate],DAY),
-DATEDIFF(Dates[OtherDate],Dates[Date],DAY )
)

ElizabethTachji — Fri, 16 Aug 2019 23:26:24 GMT

Hi,

How do you count only work days between two dates?

Thanks

Elizabeth Tachjian

elizabeth@analyticsrealtime.com.au

Anonymous — Sun, 18 Aug 2019 14:10:42 GMT

Just add a column to your Date table that will mark a date as a weekday or weekend day and then filter appropriately in your measures.

Best
Darek