Forum Discussion
Dead stock value
Hello, I am trying to calculate dead stock value with powerBI. It is value of the stock taking in account only the articles which weren't used at least since 1 year. To do this I have 2 tables. ...
I know this is a old post, but for others who are curious on how to approach the problem having similar tables as yours.
Setup:
1. Dimension Item table (also acting as your ARTICLE table) -contains article numbers and stock as of today.
2. Facts Ledger table - containing all the items sold with dates.
Approach
1. Active relationship between Item table to Ledger table. One to Many.
2. Date table linked to the dates of Ledger table
3. Filter on page to choose cut off dates for deadstock evaluation.
4. Measure to get the DISTINCT items ( tip use VALUES) and insert logic for your deadstock. The measure should be used against the Item Table Dimensions.
Best,
Yuvi