Forum Discussion
Slow Moving Inventory
- 2 years ago
If you need to determine if the inventory of each SKU has changed over the last six weeks you can do this
by creating measures and columns that calculate the difference in inventory quantity over time.
You didn't provide enough information so I am assuming the following :
- Current Inventory Quantity: A measure to get the latest inventory quantity for each SKU.
- Inventory 6 Weeks Ago: A measure to get the inventory quantity from six weeks ago for each SKU.
- Inventory Change: A calculated column to determine the change in inventory quantity over the past six weeks.
Latest Inventory Quantity = CALCULATE( SUM(Inventory[Inv Quantity]), LASTDATE(Inventory[Date]) ) Inventory 6 Weeks Ago = CALCULATE( SUM(Inventory[Inv Quantity]), DATEADD(Inventory[Date], -6, WEEK) ) Inventory Change = [Latest Inventory Quantity] - [Inventory 6 Weeks Ago]Then create another calculated column to flag slow-moving inventory :
Slow Mover = IF( [Inventory Change] = 0, "Slow Moving", "Active" )
If you need to determine if the inventory of each SKU has changed over the last six weeks you can do this
by creating measures and columns that calculate the difference in inventory quantity over time.
You didn't provide enough information so I am assuming the following :
- Current Inventory Quantity: A measure to get the latest inventory quantity for each SKU.
- Inventory 6 Weeks Ago: A measure to get the inventory quantity from six weeks ago for each SKU.
- Inventory Change: A calculated column to determine the change in inventory quantity over the past six weeks.
Latest Inventory Quantity =
CALCULATE(
SUM(Inventory[Inv Quantity]),
LASTDATE(Inventory[Date])
)
Inventory 6 Weeks Ago =
CALCULATE(
SUM(Inventory[Inv Quantity]),
DATEADD(Inventory[Date], -6, WEEK)
)
Inventory Change = [Latest Inventory Quantity] - [Inventory 6 Weeks Ago]
Then create another calculated column to flag slow-moving inventory :
Slow Mover =
IF(
[Inventory Change] = 0,
"Slow Moving",
"Active"
)