Forum Discussion
Calculating Deadstock
MalGr123 , Create a measure like this
Rolling 2 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-2,Day))
This last 2 days sales , you can make it N number days as per need
Not sold = if(Isblank([Rolling 2], 1,blank)
Use this as filter for a visual you have common item dimension and inventory value (This measure is not blank is our filter)
The approach is the same as
Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458
MalGr123 , Create a measure like this
Rolling 2 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-2,Day))
This last 2 days sales , you can make it N number days as per need
Not sold = if(Isblank([Rolling 2], 1,blank)
Use this as filter for a visual you have common item dimension and inventory value (This measure is not blank is our filter)
The approach is the same as
Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458
hi amitchandak . Thanks for the super fast suggestion. Getting a bit closer to my desired solution.
Created the "Not sold" measure just as you described and I am getting to that point that I can create two bar charts like this:
First one with the inventory value of all parts and one with the inventory value of all parts without sales in the given period. Problem is that in my real dataset, I have thousands of different materials, so using that bar chart is not really useful. Is there any way to summarise that information? Basically what I need is one bar with total inventory value and one with total inventory value of all parts not sold without the material dimension as a legend?
MalGr123 , A measure like this should give you count of material sumx(values(Table[Material),if(Isblank([Rolling 2]), 1,blank()))
Or In place of 1 have a measure from the inventory table to give you sum on inventory qty/value
I think I may not have described exactly what I wanted. But your comment helped to me to get my desired solution. So I am sharing the final measure.
Which gives me the possibility for that bar chart:
Thank you very much
