Forum Discussion
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
- amitchandakSuper User
NMC20 , Is it like active between installation date and Removal date
Refer these solutions
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzMSame as Active Employee
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU - AnonymousNot applicable
Hi, NMC20
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Best Regards
Yongkang Hua