topic Daily Budgets - split monthly values into days. in DAX Commands and Tips

Daily Budgets - split monthly values into days.

ROG — Thu, 21 Jul 2022 10:32:59 GMT

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.

Re: Daily Budgets - split monthly values into days.

amitchandak — Thu, 21 Jul 2022 11:19:09 GMT

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-Convert-to/ba-p/1657798

Re: Daily Budgets - split monthly values into days.

ROG — Thu, 21 Jul 2022 11:55:19 GMT

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.

Re: Daily Budgets - split monthly values into days.

Anonymous — Tue, 26 Jul 2022 09:03:12 GMT

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.