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),
Proud to be a Datanaut!
Here is an ugly alternative 🙂
Column = IFERROR(DATEDIFF(Dates[Date],Dates[OtherDate],DAY),-DATEDIFF(Dates[OtherDate],Dates[Date],DAY ))
How do you count only work days between two dates?
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Find out where you can attend!