Unable to calculate next month Forecast

[Akbera1]

Good Day Guys,

I have data, date and material wise sales forecast. When comparing acutal sales with forecast i am unable to calculate next month forecast. please support, if required i can provide sample data aswell.

Regards,

SMA

[Akbera1]

basically i trying to create a dashboard with month calender over it. every thing will be calculated over it. like calender date forecast and calender dated sales, i want one more column of next month forcast eg: column Jan-24 forcast column jan-24 sales column 3 feb-24 forcast. i  am unable to calculate feb forcast

[Akbera1]

Material	Date	Quantity
A	01-01-2024	10
B	01-01-2024	10
C	01-01-2024	20
A	01-02-2024	10
B	01-02-2024	15
C	01-02-2024	20
A	02-01-2024	15
B	02-01-2024	10
C	02-01-2024	10
A	02-02-2024	15
B	02-02-2024	10
C	02-02-2024	20

[v-cgao-msft]

Hi @Akbera1 ,

How to provide sample data in the Power BI Forum:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Hope it helps.

Best Regards,
Gao
Community Support Team

[Akbera1]

please check sample data

[v-cgao-msft]

Hi @Akbera1 ,

What is the Forecast Value for February? How is it calculated? It would be helpful if you could provide the expected output and the logic used to calculate the forecast.

Best Regards,
Gao
Community Support Team

[Akbera1]

Material	Month Forecst	Actual Sales	Next Month
A	20	Not Provided in chart	30
B	25	Not Provided in chart	20
C	40	Not Provided in chart	30

this is how i want to create my chart. sample data i provided is date wise and material wise and dashboard will run by calender dates.

[v-cgao-msft]

Hi @Akbera1 ,

Please try:

Next Month = CALCULATE(SUM('Table'[Quantity]), NEXTMONTH('Date'[Date]))

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Akbera1]

it's working, thanks brother. let me check with results then mark it accepted 🙂 

[danextian]

Hi @Akbera1 

One likely reason is you are missing future dates in your table so there are not dates to as assign future values to. And yes, please provide  a workable sample data, your expected result from that and the reasoning behind.

[Akbera1]

i have future dates, unable to calculate it. check sample table

[danextian]

You have the sample data but what do we do with that? What is the expected result? How is the forecast going to be computed/ what is the logic?

[Akbera1]

basically i trying to create a dashboard with month calender over it. every thing will be calculated over it. like calender date forecast and calender dated sales, i want one more column of next month forcast eg: column Jan-24 forcast column jan-24 sales column 3 feb-24 forcast. i  am unable to calculate feb forcast

[bhanu_gautam]

@Akbera1 , Share sample data

[Akbera1]

its shared.. please check.