Forum Discussion

PBI_37's avatar
PBI_37
Icon for Helper I rankHelper I
2 years ago
Solved

Slow moving stock

Hi everyone,

 

I have a table with stock movements by product and batch.

I would like to identify slow-moving stocks (products/batches in stock without movement for at least 2 months).

I have already calculated the stock of each product / batch.

For example, if it is May 31, 2 products / batches are slow-moving (yellow rows) :

 

Here is the link of the PBI file :

https://drive.google.com/file/d/1jUJs-0HYktKttd6uPUVOyF3XBG2F_7In/view?usp=sharing

 

Thank you for your help.

Need Help
  • Rupak_bi's avatar
    Rupak_bi
    2 years ago

    Hi,

     

    Please see below result. Hope this meets your ask. Just modify the datediff formula to get desired result from your expected date. 

     

    st 

     

6 Replies

  • Rupak_bi's avatar
    Rupak_bi
    Icon for Super User rankSuper User
    2 years ago

    Hi,

     

    Hope this solves your ask

     

    If you find this helpfull, please accept as solution.

    • PBI_37's avatar
      PBI_37
      Icon for Helper I rankHelper I
      2 years ago

      Thank you Rupak_bi.

      But this is not exactly what I need. In your screenshots, the batch number does not correspond to the correct product. Batch A1 is displayed on all products.

      In the original table, batch A1 is linked only to product A.

      For example, if I analyze stocks as of May 31:

      Product A / Batch A1 : the stock is zero so no “slow-moving”

      Product A /Batch A2 : the quantity in stock is 300 and the date of the last movement >= 2 months => "slow-moving" = Yes

      Product B /Batch B2 : the quantity in stock is 200 and the date of the last movement <= 2 months => "slow-moving" = No

       

      Thank you for your help

      • Rupak_bi's avatar
        Rupak_bi
        Icon for Super User rankSuper User
        2 years ago

        Hi,

         

        Please see below result. Hope this meets your ask. Just modify the datediff formula to get desired result from your expected date. 

         

        st 

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi PBI_37 ,

     

    I have a feeling that you may have a bit of a problem with your relationship screening, and I have made many attempts to get the following results:

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

    • PBI_37's avatar
      PBI_37
      Icon for Helper I rankHelper I
      2 years ago

      Thank you v-tianyich-msft.

      This is not exactly what I need.

      I want to analyze stocks based on a date that I select in a slicer such as 05/31/2024.

      In this example, there are 2 products / lots (A / A1 and B / B1) that are in stock with no movement for at least 2 months.

      I hope my data model is correct.

       

      Thank you for your help