Forum Discussion
mohammadyousaf
Resolver II
Resolver IIRunning total with forecast
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 some...
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.
vanessafvg
Community Champion
Community Championplease 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.
mohammadyousafThank 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.