Deducting a measure so it is reflected per weeks

[nivanovic]

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

[pranit828]

Hi @nivanovic 

Can you please explain it with example in a table and the expected output.

Regards,

Pranit