Forum Discussion
ROG
Responsive Resident
Responsive ResidentDaily Budgets - split monthly values into days.
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 ...
amitchandak
Super User
Super UserROG , 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
ROGHi 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.