09-28-2018 02:45 AM
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.