Tracking data from live inventory system

Anonymous — Mon, 27 Mar 2023 05:27:47 GMT

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?

topic Tracking data from live inventory system in DAX Commands and Tips

Tracking data from live inventory system