Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

A 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.

Reply
Anonymous
Not applicable

Tracking data from live inventory system

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?

0 REPLIES 0

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.