Forum Discussion
Help :( - Monthly Budget - Daily
Dear
I am making a sales/budget report, and I would like to see the option or way to be able to determine the value of the daily budget according to the monthly budget that each store has and each line of business according to the days that are worked within the month Monday - Saturday.
Budget Table:
Problem:
Annual Royal:
Monthly
I have not been able to do it daily as the following problem happens to me:
The value is only left on day 1 of the month.
Please be very grateful for your help, it is the first post I make in this forum and I have been trying to solve this problem for a week
Best regards!.
3 Replies
Pamicas , There are couple of ways. I have blog from yearly to daily. But you have similar functions to make it from monthly to daily datesmtd, closingbalancemonth
powerbi Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290
PowerBI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400
Hi amitchandak , what is the difference between the 2 methods ?
I want to convert a Monthly budget to a Daily budget to do more precise analysis.
Do you think I can do it with one of your method ?
Sincerly
Hi Pamicas ,
If possible,could you pls provide your sample data in editable format with expected output?
Much appreciated.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
