Identify products that haven't been moved in months

[Anonymous]

Good day

I would like to be able to identify which products have not moved in a certain time in the inventory in order to segment them into categories such as: three months without movement, six months without movement, one year without movement.

I have the following table, at the beginning of the month it is filled with the quantity in inventory of each product:

Date	Product	Quantity
01/01/2020	Chair	50
01/01/2020	Table	30
01/01/2020	TV	30
01/01/2020	Monitor	20
01/02/2020	Chair	50
01/02/2020	Table	25
01/02/2020	TV	30
01/02/2020	Monitor	20
01/03/2020	Chair	50
01/03/2020	Table	15
01/03/2020	TV	15
01/03/2020	Monitor	20
01/04/2020	Chair	50
01/04/2020	Table	25
01/04/2020	TV	15
01/04/2020	Monitor	20

You would need to create a filter to be able to put something like:
* Moving
* No movement in three months
* No movement in six months
* No movement in twelve months

And according to that filter to be able to filter my report with the information of those products.

How could it be done?

[Ashish_Mathur]

Hi,

On the data that you have shared, could you show the expected result.

[lbendlin · Accepted solution]

For each product category you find the latest date when the value was different from the current date's (last date's) value*. Subtracting both dates gives you how long ago the last movement was for that product.  Compare that value to your buckets. et voila.

* remember this is context dependent. You need to create the measure in a way that it calculates this for EACH of your dates, unless you specifically only want to show the latest result.  I removed the last data point for Monitor to illustrate that.