Forum Discussion
NB689
Helper I
4 years agoSumming 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[Login], Sheet1[Logout], Day )
) +1Based on this data below, I would like to see the sum total of these days. So instead of gettting a "5" I would expect to see a "9".
Thank you
Why don't you just add colnum?
your +1 is not correct.
Days Duration = SUMX (
Sheet1,
DATEDIFF ( Sheet1[Login], Sheet1[Logout], Day )+1
)
1 Reply
- vapid128
Solution Specialist
Why don't you just add colnum?
your +1 is not correct.
Days Duration = SUMX (
Sheet1,
DATEDIFF ( Sheet1[Login], Sheet1[Logout], Day )+1
)