Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a dataset which is a live view of our inventory system. I want to create a dashboard that tracks if any specific items remain in the same location in inventory for more than 12 hours.
The data I can pull in is itemID and location . I want to have two tables, one being the table of items and their location before the refresh and one being the same table after the refresh. If any rows match, that means that item has been in the same location for a certain amount of time (Based on refresh time). I want to then record the amount of time that itemID has spent in a certain location, and only display the ones that are in stuck in the same location for 12 or more hours.
Is there a way to do this in PowerBI?
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |