Forum Discussion
NB689
Helper I
Helper ISumming Differences in Login/Logout Times
I have created a measure that sums the number of days (counting calendar dates, not full 24 hour days) by using the following: Days Duration = SUMX (
Sheet1,
DATEDIFF ( Sheet1[Logi...
Why don't you just add colnum?
your +1 is not correct.
Days Duration = SUMX (
Sheet1,
DATEDIFF ( Sheet1[Login], Sheet1[Logout], Day )+1
)
vapid128
Solution Specialist
Solution SpecialistWhy don't you just add colnum?
your +1 is not correct.
Days Duration = SUMX (
Sheet1,
DATEDIFF ( Sheet1[Login], Sheet1[Logout], Day )+1
)