Age of Inventory Calculation

[lizaflor]

Hi, I am a newbie in Power BI and I was given a project that will compute for the Age of Inventory. Can anybody help me on the calculation of it? Below is my sample data:

I have an ending Inventory of 549 , based on my sell-in information, I need to match my Inventory units to it and return the appropriate age group to show how long the Inventory is sitting in the warehouse. The desired result will show how many units are age 1-3 months, 4-6, 6-9 and so on. 

Thank you in advance for any input that will be given to this inquiry.   By the way, these are my models.

[Tanushree_Kapse · Accepted solution]

Hi @lizaflor ,

You can create different measures to show the number of inventory units for different ages:
1. For 1-3 months= Calculate(SUM(Sell-in), filter(table_name, Group="1-3 months"))
Likewise you can create measures for other intervals too.

I believe this is what you wanted.

[lizaflor · Accepted solution]

Hi @Tanushree_Kapse, thank you so much for this helpful insight. Indeed this is what I wanted. I was able to solve the aging of Inventory using the above measure. I really appreciate your help. God bless.

[Tanushree_Kapse]

@lizaflor Glad to help!😄

[Tanushree_Kapse · Accepted solution]

Hi @lizaflor ,

You can create different measures to show the number of inventory units for different ages:
1. For 1-3 months= Calculate(SUM(Sell-in), filter(table_name, Group="1-3 months"))
Likewise you can create measures for other intervals too.

I believe this is what you wanted.