Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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......
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |