This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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 May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.