Running total with forecast

[mohammadyousaf]

Hi, can someone please help me with a dax. I want to calculate running total in new column which should go beyond the actual dates perdicting the forecast based on the current output (average or something other method) until it reaches to a set quantity, let's suppose that is 480.  

I want to visualize it on a graph where it perdict when the 480 quantity will be achieved based on the current rate of progress. 

Thank you. 

[vanessafvg]

please provide data in text format.  However in terms of forecasting you will need to use potentially other tools such as python or some tool that does prediction, this is not a power bi function, you can use the forecast in the linechart but its not available in a matrix - however it depends on how you want to define your forecast.

[mohammadyousaf · Accepted solution]

Thank you, I found the solution by using quick measure to create a running total than putting it to line chart and using PowerBI inbuilt forecast for the next 30 days based on historical data.