Reply
Frequent Visitor
Posts: 8
Registered: ‎09-27-2018

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