Forum Discussion
Filtering on times
okay so you want to check out the new August product release video - where it demos the new range slicer.... it creates a measure that has values that you can use.... just watched it myself. can't help you further in this as it is new to me but check it out and then see if it advances your cause......
For ID1 (and potentially for a unique Date);
TimeX (in this case 11:00)
TimeX>= TimeIn AND TimeX<= TimeOut
one presumes only 1 record satisfies that case and it has a Location = 1
this is just the logic, not the DAX statements (which would depend on the tables) but a time field is able to do this style logic.
Hi CahabaData
Thanks for replying :)
I understand the logic you mentioned, my difficulty is now how would I filter that in a report.
For example I would like a slicer as follows:
I would use the above slicer to identify the hours and then a seperate (or inclusive if I use decimal values) slicer for the minutes.
It would then check the times within the table containing the Time In (TI) and Time Out (TO) to say that that time is between TI and TO and therefore would show that ID x would be in location y.
Thanks,
J
okay so you want to check out the new August product release video - where it demos the new range slicer.... it creates a measure that has values that you can use.... just watched it myself. can't help you further in this as it is new to me but check it out and then see if it advances your cause......
Have done :)
Seems like this new release has come at just the right time.
Thanks for the help anyway
