cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
megan2010 Frequent Visitor
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!
stock age.png
 
stock age.png
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
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
Community Support Team

Re: grouping inventory by in stock day from today

Hi @megan2010

 

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
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.