Filtering on times

[opticshrew]

Hi all,

Having a little issue here....

I essentially want to say that at time x , ID will be in Location y.

(e.g. At 11:00am I know that ID 1 is in location 1)

I could filter on Time In or Time Out however I can't say that at a time between these ID will be in location.

I was thinking I could find all times between Time In and Out and then unpivot to rows however that would just create loads more rows to load. (link with a time table)

Any ideas folks?

Thanks,

J

[CahabaData]

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.

[opticshrew]

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

[CahabaData · Accepted solution]

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......

[opticshrew]

@CahabaData

Have done 🙂 

Seems like this new release has come at just the right time.

Thanks for the help anyway