Monthly Budget to daily

[vwiles84]

I have a data source that has Date and Monthly budget.  I have been able to expand the month out to individual days and carry the monthly budget told to each row for the expanded dates but I need some additional guidance. How can I create another column that calculates the daily budget for each day of the month based of the month total? Screen shots provided. 

[vwiles84 · Accepted solution]

I found a solution. I created 2 columns with variations of this command: 

Store Target = CLOSINGBALANCEMONTH(sum('2022Targets'[ Target])/(maxx('2022Targets',DATEDIFF('2022Targets'[StartDate],'2022Targets'[EndDate],day))+1),'Date Table'[Date])