Create a cumulative budget line from budget with a start and end date.

[ErikBI]

Hey everyone,

I've been thinking about this for a while, but I am nowhere near as knowledgable to figure out how to do it. I'll try my best to explain it! 

Below Is a graph where I show the cumulative spendings in blue.

The black line (drawn with MS paint) is what I'm trying to achieve, which is supposed to be the budget line.

My Budget data is as following with a budget price, start and end date. 

From what I understand, to achieve this line I need to spread the budget over each day between the start and end date, and then make that into a running total. But I am having trouble with this. I don't know DAX nearly as well!

I have attached the pbix file below. In here you can see all the data that I'm using.

Example.pbix 

Source data 

I hope there is a way to achieve this! That would be fantastic. If you have any questions let me know!

Cheers.

Erik

[v-xuding-msft]

Hi @ErikBI ,

You could reference the video and the blog to learn how to spread date.

List dates between two dates in Power Query 

Fill dates between dates with Power BI / Power Query 

[ErikBI]

This looks very helpful. I'll look into it! Thanks.

[mwegener]

Hi @ErikBI ,

was your problem solved?

[amitchandak]

@ErikBI , You can refer this file for allocation

https://www.dropbox.com/s/fnq82ksdzk1lqs3/Target_allocation_daily.pbix?dl=0

example of cumulative

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=maxx(date,date[date])))
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=max(Sales[Sales Date])))