Daily Budgets - split monthly values into days.

[ROG]

Hi all,

On the table below I have budget by monhly only, but I would like to drill down to week as well, so I can have the blue line on the second chart feeding through the weeks. 

I believe if I have the monthly values split by days I would have the expected result. Hopefully some of you are able to assist me. 

Many thanks.

[Anonymous]

Hi @ROG 

Are the values in your source data by day? If so, you can completely use the date hierarchy to display it in the visual by day, week, and month. 

If you don't know how to operate , you can also provide your original data with pbix file(remove sensitive info) or execl to us , so that we can deal with your problem easier .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ROG , refer if this can help

Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-...

[ROG]

Hi @amitchandak 

I actually tried it before dropping my questions. Unfortunately, for some reason it didn't work for me. 

My daily target (named dailu budget) is incorrect. What am I missing? 

Daily Budget = CLOSINGBALANCEMONTH(SUM(Budget_Churn_2022[MonthStart])/MAXX(Budget_Churn_2022,DATEDIFF(Budget_Churn_2022[MonthStart],Budget_Churn_2022[MonthEnd],DAY))+1,'🔎Calendar'[Date])

Many thanks.