Help :( - Monthly Budget - Daily

[Pamicas]

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

[v-kelly-msft]

Hi  @Pamicas ,

If possible,could you pls provide your sample data in editable format with expected output?

Much appreciated.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

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

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-C...

[Anonymous]

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