Filter for a specific date (-30 days<specific date<90 days)

Hi Anonymous ,

I would add new columns to the table where your release dates are stored in Power Query like this:

// openDate - 30 days before:
Date.AddDays([releaseDate], -30)

// closeDate - 90 days after:
Date.AddDays([releaseDate], 90)

Then in your DAX measures you can use these dates to dynamically select this window when selecting different products in the report, something like this:

_windowSales =
CALCULATE(
  SUM(factTable[Sales]),
  factTable[salesDate] >= productTable[openDate],
  factTable[salesDate] <= productTable[closeDate]
)

There's some considerations around relationships that I can't address without seeing your model (I've assumed you have a relationship between productTable and factTable based on [Product]), but the principle I've outlined is how I would go about it.

Pete