Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Using Past Average to Predict Future Outcome

I current have this DAX AverageDemanLast6Weeks = VAR StartDate = TODAY() - 42 VAR EndDate = TODAY() RETURN AVERAGEX(     FILTER(         'Date',         'Date'[Date] >= StartDate && 'Date'[D...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you for getting back Yolo,

So here is what I am trying to achieve. 

I have a DAX measure that has calculated the Average demand for the last 6 weeks. 
I want to have a new DAX that will do the following :
If I  select any day of the week in the future. For instance, if I select a Monday, what I would love to see the Average Demands for the Last 6 Mondays (The 6 Mondays in the calculated DAX)

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

Can you provide some sample data?

 

Best Regards

Yolo Zhu