Forum Discussion
Stock Ageing Analysis Using FIFO Calculation
Hello clever people, I have been struggling to create an Ageing view of the stock on hand in my two retail stores. I have the daily Stock on Hand (SOH) and Sales for each store by date and SKU,...
Hi Amitchandak,
Thanks for the links... Unfortunately, I have been through all of them already over the past week and they do not deal with the same problem.
Anonymous , i am try to check option of bucketing like
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
something like this
Age bucket qty sum = CALCULATE(Sumx(filter(VALUES(SOH[Invtid]), [Age] >=min('Agebucket'[Age bucket start]) && [Age] <=max('Agebucket'[Age bucket end])),SOH[Value Unit]))
But i doubt the lowest level