Slow Moving Inventory

[KB88]

Hello,

I am currently trying to create an inventory dashboard for my company. The Data within my inventory query includes Division, Date, Material, Inv Price, Inv Quantity, Material class. I have 1000+ skus and every sku is updated on Fridays. So if Sku 101 has 100kg on 1/5/2024 and 100kg on 1/13/2024 this will be shown. I am trying to figure out how to show slow moving inventory based off this information. I do not have COGS in this query.

Thanks in advance for any help!

Edit: Slow mover is anything that has not been used in 6 weeks

[AmiraBedh · Accepted solution]

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"
      )