Forum Discussion

KB88's avatar
KB88
Frequent Visitor
2 years ago
Solved

Slow Moving Inventory

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 ...
  • AmiraBedh's avatar
    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"
          )