Forum Discussion
Solved
Excess Stock by date
Hi All, Download Sample Data - Excel I am trying to do Excess Stock analysis in Power BI but can't get this work. Please see below for example and Result: DEMAND DATA: STO...
Hi mb0307 ,
"Total Available Stock Meeting Demand" = CALCULATE(SUM(STOCK[Stock]),FILTER(ALL(STOCK),STOCK[Available Date].[Month]=SELECTEDVALUE(DEMAND[Date of Demand].[Month])&&STOCK[Available Date]>=SELECTEDVALUE(DEMAND[Date of Demand]))) Stock NOT Meeting Demand = CALCULATE(SUM(STOCK[Stock]),FILTER(ALL(STOCK),STOCK[Available Date].[Month]=SELECTEDVALUE(DEMAND[Date of Demand].[Month])&&STOCK[Available Date]<SELECTEDVALUE(DEMAND[Date of Demand]))) Excess Stock = [Stock NOT Meeting Demand]-SUM(DEMAND[Demand])Best Regards,
Jay
Can we see your data ?
if you have this 2 tables you need to merge your tables on product and month/year
See this I create the query, I need more information about business rules to create total's