grouping inventory by in stock day from today

[Anonymous]

Hi,

I want to create a charts shows number of inventories by 1 month, 3months, 6months, 1 year, 2years, 3years old.

I curently created a stock age colum by

stock age = TODAY()-'MODEL SORT'[In Stock Date]

I wish to update my data weekly so the stock so that the stock age will change.

below is the sample table I've got.

Thanks!

[Ashish_Mathur · Accepted solution]

Hi,

=If([Stock age]<=30,"1 month",if([stock]<=90,"3 months",if([stock]<=180,"6 months".....

Complete the IF function.

[v-cherch-msft]

Hi @Anonymous

It seems you need create a new table with group column. Then link them by month columns. Below is the sample file for your reference.

Amount = CALCULATE(DISTINCTCOUNT(Table1[MMD]))+0

Regards,

Cherie