Daily Forecasting based on monthly Budget

prashanth0626 

It's doable, in Power Query and DAX: Refer these links:

https://community.powerbi.com/t5/Desktop/Divide-monthly-budget-across-all-days-in-the-month/td-p/894957

https://community.powerbi.com/t5/Desktop/Annual-budget-split-monthly-with-seasonality/td-p/358327

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn

prashanth0626 , Create a table with sales of those 6 months. Add 182 days (Weekdays will move at the correct position) to each date.

New date = [Date]+182

Assume your total target it X.

Create a new column in this table

New target = [X]* Divide([Sales],sum(Table[Sales]))

Fowmy amitchandak 

Thanks for the suggestion, but all of those actually don't serve my purpouse. I am not looking for a average split by day.

For eg, IF a month budget is 1000 i basically want to split the 1000 into day target by looking at my last 6 month sales pattern. I need two patterns to be utilized 1. As we go towards month end our sales increases so that should reflect in my forecast 2. We usually have higher sales on weekends (Thu-Sun). [Both of those looking at my last 6 month sales]

Thanks

Hi  prashanth0626  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy