Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Show only data in a date range

Hello,
Im building a report that helps with tracking parts in facility. a tracker goes on an item and gets pinged as it moves around the facility. 
Table 1 shows the ITEM I am tracking, the tracker TAG NAME, tracker TAG ID, and the START and END time that the tracker was on the item (since they are reusable).

Table 2 shows the location history, and the time it was pinged. 
Table 3 links the TAG ID to the TAG Name, since table 2 doesnt have the name from the data export. (TAG Name is actually visible on the trackers and ID is not). 
And the Result Table is what I want to see. I want to be able to filter for a Item, then PBI will check which TAG ID it has (or had), then only show location history for times within the START and END times. 

I do have an attempt built out that doesnt show much private data but if this sample isnt close enough to the real thing i can work on sharing that. LMK if you need any clarification.

Hopefully this works for the file: https://drive.google.com/file/d/1iRi_pwqcgbDh6aPYRq329aCGZO_nka0J/view?usp=share_link

3 Replies