Solve for average sales since a certain date * w/ pictures

[water-guy-5]

Hello,

Here is an example of a scenario I am trying to solve with some dummy data provided. Lets say I have three tables.

Table 1 is a Date Dimension table
Table 2 is a Dimension table for my store locations. One of the columns is a date that marks when the "executives" met with the manager to give them a sales pep talk.

Table 3 is a Fact table that records the sales record for a certain day and a certain location. Lets pretend that these records date back to the last decade.

I am trying to calculate what the average daily sales were for a certain store between the current date and when the sales pep talk with the manager took place. 

Something along the lines of
Measure = 
CALCULATE(
AVERAGE(Table 2[Sales]),
DATESBETWEEN(TODAY(), Executive Date)

Thanks!

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523