Problem Statement :- Inventory amount by period Analysis

[admin11]

Hi All

Below is the inventory analysis report , i like to add one more probem statment :- Inventory amount by period.

Meaning i can know my inventory amount by period. For example :-

Period......... Amount 

0-1 year......10K 

1-2 year......5K 

2-3 year......3K 

3-4 year......9K

>5k..............20K 

Below are some of the Report i have already created :-

Below is my sample PBI file :-

https://www.dropbox.com/s/ezp9jlxsx5406jw/PBT_V2021_306%20Inventory%20problem%20statement.pbix?dl=0

Raw data :-

https://www.dropbox.com/s/sp910ax9dde7bla/INVC_TI.csv?dl=0

Hope some one can share with me.

Paul Yeo

[amitchandak · Accepted solution]

@admin11 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[amitchandak · Accepted solution]

@admin11 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[admin11]

@amitchandak 

Thank you for wanted to provide the solution. what i want is base on the " Last Sales " field , is the date the items sold to customer. for example if the date first row the date 27 Jan 2018 , mean this items already stock for 3 year ago. what i need to compute all the stock items base on Last Sales date and create the report to show year vs amount report.

[amitchandak · Accepted solution]

@admin11 , if you want based on today, you can create a new column in INVC

Years since = var _1 = DATEDIFF([Last Sales],TODAY(),YEAR)
return 
Switch( True(),
_1<= 1, "  0-1 Year", 
_1<= 2, "  1-2 Year", 
_1<= 3, "  2-3 Year" , "Other"
)

[admin11]

@amitchandak 

Great it work fine. Thank you

Paul