Days Between Dates with Negatives

Greg_Deckler · ‎08-12-2016

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Phil_Seamark · ‎08-16-2016

Here is an ugly alternative 🙂

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

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

ElizabethTachji · ‎08-16-2019

Hi,

How do you count only work days between two dates?

Thanks

Elizabeth Tachjian

elizabeth@analyticsrealtime.com.au

Elizabeth Tachjian

Anonymous · ‎08-18-2019

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

Helpful resources