In month forcast in power bi

[rajkumar2211]

Hi,

I have date wise card turn over data for perticulare month.

Date            cardturnover

2022-01-01  34345

2022-01-02  45346

2022-01-03  31267

2022-02-04  34590

2022-02-05  37812

I want to forecast what will the card turnover values for the remaing days of the month or what will be the forcast value for the next 7 days.basically how to genrate in month forcast in power bi.

[Hariharan_R]

Hi @rajkumar2211 

Power BI line chart visual can give you the forcast like below but if you want to see in the table visual then you need to use R or Python library to calculate.

Added reference link for reference - https://community.powerbi.com/t5/Desktop/Generate-Forecast-Value-in-a-Table/m-p/107638

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[rajkumar2211]

Hi @Hariharan_R ,thanks for your reply.
My envirnment doesnot allow R or Python to use .I am looking to do it in power BI using dax formula and measures.Please help with dazx formula.

[Hariharan_R]

Hi @rajkumar2211 

Sharing you some of the resources.

https://www.youtube.com/watch?v=CAq02_Wf2sE

https://www.youtube.com/watch?v=U7sl7guoxMI

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin