Forum Discussion
Zaynah16
Helper I
4 years agoRolling forecast
Hi Guys, Please could someone help, I need to create a rolling forecast in a matrix with a view of the next 3 months from 2021-2025 to refrelct WP( (market Column ) and BP( Market Column ) I'...
AnkitKukreja
Super User
4 years agoHi! Zaynah16
You can use the line chart to create a rolling forecast automatically, you can find the steps to do the same below.
https://community.powerbi.com/t5/Desktop/Rolling-forecast-please-help/m-p/358173
You can also use follow this video to use dax https://www.youtube.com/watch?v=njjEkkoyxl0.
Hope this helpw. If not, please provide sample file and your expected outcome.