Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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),
Here is an ugly alternative 🙂
Column = IFERROR(
DATEDIFF(Dates[Date],Dates[OtherDate],DAY),
-DATEDIFF(Dates[OtherDate],Dates[Date],DAY )
)
Hi,
How do you count only work days between two dates?
Thanks
Elizabeth Tachjian
elizabeth@analyticsrealtime.com.au
User | Count |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |