cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## grouping inventory by in stock day from today

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: grouping inventory by in stock day from today

Hi,

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

Complete the IF function.

2 REPLIES 2
Community Support Team

## Re: grouping inventory by in stock day from today

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User

## Re: grouping inventory by in stock day from today

Hi,

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

Complete the IF function.