Days Between Dates with Negatives

[Greg_Deckler]

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]

Here is an ugly alternative 🙂

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

[ElizabethTachji]

Hi,

How do you count only work days between two dates?

Thanks

Elizabeth Tachjian

elizabeth@analyticsrealtime.com.au

[darlove]

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