cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Nikola