Calculating Sales After an Event using Two Tables

[klu31415]

I was hoping someone would be able to help me with this. I currently have two separate tables each with the below values. What I want to do is calculate the sum of sales that occurred 60 days after the event date occurred for all item/store combinations. I'm struggling to get any DAX to take both columns into account.

Actions

• Item
• Store
• Event Type
• Event Date

Sales

• Item 
• Store
• Date
• Total Sales

[v-frfei-msft]

Hi @klu31415,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,

Frank

[v-frfei-msft]

Hi @klu31415,

I made one sample here for your reference. I created a measure as below.

Measure = CALCULATE(SUM(Sales[total sales]),FILTER(ALL(Sales),Sales[date]<=SELECTEDVALUE(Actions[Event date])+60 && Sales[date]>=SELECTEDVALUE(Actions[Event date])))

And here is the result.

For more details, please check the pbix as attached. If it doesn't meet your requirement, kindly share your samle data and excepted result to me.

https://www.dropbox.com/s/58v3v71t371cn7f/Calculating%20Sales%20After%20an%20Event%20using%20Two%20T...

Regards,

Frank