The basket sales of orders contain certain items

@Melissa Thank you! I will take a look.

Mike

Hi, @Melissa, I modified your measure for Promotion SKU within 4 weeks prior to campaign start date, but the result is not right.

SKU Sales 4 weeks prior to campaign =
CALCULATE( [Sales],
FILTER( VALUES(Dates[Date]),
Dates[Date] >= MIN( Promo_SKU[Promo_start] ) -28 &&
Dates[Date] <= MAX( Promo_SKU[Promo_start])
)
)

Did I do something wrong? Thanks!

Mike

So I may have misunderstood your requirement earlier because you are calculating [Sales] not [Basket Sales] by the looks of it…

What do you want to achieve?

@Melissa You have helped me get more than I need. I feel so bad for keeping bombarding you with new questions. I promise this will be my last one. On the Dashboard you helped me build, it show the SKU sales and basket sales for a selected campaign, I am wondering if I can show the campaign SKU sales with the 4 weeks period prior to a campaign start date?

image

My formula just did not work as I expected.

Thanks for all your help! Cannot say thank you enough to you.

Mike