Forum Discussion

NMC20's avatar
NMC20
Helper I
1 year ago

Incremental Monthly Costs

I am looking to create a cumulative measure which calculates [Upfront Costs] + [Monthly Costs], with the [Monthly Costs] being added each month (this will be the same price every month).

 

I would like this to start at [Installation Date] and end at [Removal Date] so I can have it displayed on a line chart like below. I have a number of different sites which are included as a filter on the report so the costs and dates will be different when the filter changes. 

 

 

 

 

For example

I already have this in Power BI:

(In this example, the [Removal Date] is in 2029. The [Cost] line is just the [Cost] column (minimum value) but I would like this to be a measure which accounts for the monthly increase in cost to us and predict the cost all the way up until removal).

 

Want to Have

This is a dummy example of what I would like which I have made in Excel:
In this example, [Installation Date] would be Jan 25, [Today] would be May 26 and [Removal Date] would be Nov 26

 

 

So in this dummy data for this pretend site, the [Upfront Cost] was £1000 and the costs increase by £100 every month. It allows me to see that we would hit our breakeven in May 25 (when the cost line crosses over with sales line) and then see how much profit would be made after that. I have another support request for the projected revenue but the cost line would be a good win!

 

 

Thanks in advance!

2 Replies