Super User
Posts: 6,603
Registered: ‎07-11-2015

Days Between Dates with Negatives

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),

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super User
Posts: 1,970
Registered: ‎11-29-2015

Re: Days Between Dates with Negatives

Here is an ugly alternative Smiley Happy


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

----- Data Platform MVP (Power BI) -----