Hello,
I have a dax measure that counts rows based on a start and end time. The measure works except when the start and end time crosses midnight. I need help altering the measure to look at the date as well to get an accurate count. file is attached.
Thanks!
Your attachment makes no sense
Try
A15 =TIMEVALUE(TEXT(A11,"hh:mm:ss"))
B15 =TIMEVALUE(TEXT(B11,"hh:mm:ss"))
C15 =IF(INT(B11)>INT(A11),1-A15+B15,0)
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Not sure if I explained my problem well enough. I'm not looking for a calculation between the start and exit time. I'm looking for a count in my hour pivot table. So for the last data entry for 9/1/19 12:22 to 9/2/19 2:05, I want a 1 in the 23:00, 0:00, 1:00, and 2:00 rows.
My measure works fine if the start date/time < end date/time, but anything that crosses midnight does not count.
Hope that makes sense.
Not sure how/if it can be done with a DAX measure, however here is a formula based proposal.
Populate a column of discrete hours 0:00 ... 23:00
The adjacent column is populated using:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks