Calculate average time to sell a pallet of product
We sell products in-store and sometimes have display pallets to increase sales. I want to calculate how long it takes to sell pallets of different products to compare effectiveness. Issue is the sales are registered on the individual product only and not related to whether it is from a pallet or not. Therefore I am attempting to calculate sales from pallets based on the date it was delivered and count weeks until the numbers of units sold are greater than units on the pallet. I tried to make a measure for this, but it only works for the date the pallet was delivered and then stops counting (may need a cumulative sales formula). I also tried making calculated columns, but there is no relation between FacStoreOrder and FacSales. Any suggestions? Measure: AverageWeeksPalletSales= VAR AverageWeeks = DIVIDE([#Weeks], [SumPalletsSold]) RETURN AverageWeeks * [#StoresReceivedProduct] Sample data: Dim_Article Dim_Store Dim_Calendar Fac_Sales Measure Dim_Article Fac_StoreOrder Measure Article Store WeekNumber SumUnitsSold SumPalletsSold ArticlePalletUnits ReceivedPallets AverageWeeksPalletSales Product X X 10 23 0.19 120 1 5,22 Product X X 11 41 0.34 120 Product X X 12 21 0.18 120 Product X X 13 23 0.19 120 Product X X 14 17 0.14 120