Calculating actual value based on dates

[danielsjdr1]

Hi folks!

I really need some ideas on how to make this Excel Spreadsheet work in PowerBI.

What do I have:

1. Table with Date and Percentage that will be used to multiply my cost

2. Table with Task Name, Total Cost, Date Actual, Actual Value, Start Date of Project, End Date of the project

The Excel that people use here to calculate is this one, for this example (one task only):

New Cost is my target. Here's the link to  Excel file .

I need to this calculation until the date that is filtered, for example, jan-23 and for each project task (may have like 100 tasks for project). 

I'm lost in how to start, any ideas will be very much appreciated.

Tks!

[gmsamborn]

Hi @danielsjdr1 

Here is an article on Compound Growth using DAX.  It includes a simple example with a fixed growth rate and another example using a variable growth rate like your requirements.

https://exceleratorbi.com.au/compound-growth-using-dax/

Let me know if this helps.

[amitchandak]

@danielsjdr1 , if you looking for a solution to deal with between dates

Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

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-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU