Showing results for 
Search instead for 
Did you mean: 
nivanovic Frequent Visitor
Frequent Visitor

Deducting a measure so it is reflected per weeks

Dear Power BI Community,


I'm calculating Estimated Inventory per Weeks and want to deduct a fixed value or a measure so it is reflected per weeks. Formula is: Inventory + Open Purchse Orders - Average Sales which should be fixed in each row in the table. 


My measure is: sum('PO'Open PO)+[Iventory]-CALCULATE(sum(DimDate[Column]),ALLSELECTED(DimDate))


Is it the solution to create Avg Sales in DimDATE Table like I did so it is reflected on a week level given that now I cannot deduct Measure Average Sales.


Thank you