Forum Discussion
Problem Statement :- Inventory amount by period Analysis
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
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 , 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" )
4 Replies
admin11 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.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.
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" )
