Rolling forecast

[Zaynah16]

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'd like to have business Unit and sub bu per BP and WP 

Sample data 

 platform table 

Pillar

Business Unit

Name

Region

Sub Busuiness Unit

PK_Sub BU

Sub Areas

Customer

Market

Date

Value

Thanks in advance 

Zaynah                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                

[v-easonf-msft]

Hi, @Zaynah16 

I'm not sure what you want. Can you share your calculation logic？
Please share some sample data and expected result for further research.

Best Regards,
Community Support Team _ Eason

[AnkitKukreja]

Hi! @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.

[lbendlin]

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.