Forum Discussion
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
Hi Anonymous ,
see my pbi file. I have renamed some columns and created a new table and it seems it works.
https://1drv.ms/u/s!Aj45jbu0mDVJizh2nuRxyAA3L0xF?e=cXUagb
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- mangaus1111
Solution Sage
Hi Anonymous ,
I am not able to open your file
- AnonymousNot applicable
any better luck here: https://drive.google.com/file/d/1TrKjq26aTcBcMh1d5omTI2GGZeq8Rp7C/view?usp=sharing
- mangaus1111
Solution Sage
Hi Anonymous ,
see my pbi file. I have renamed some columns and created a new table and it seems it works.
https://1drv.ms/u/s!Aj45jbu0mDVJizh2nuRxyAA3L0xF?e=cXUagb
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.