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?
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!