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

 Hi Anonymous 

I don't quite understand how you want to use the last six weeks to predict future values, do you need to use Dax based on the last six weeks? Can you provide some more information and sample data so that can provide more information for you.

 

Best Regards

Yolo Zhu