Forum Discussion
Calculating actual value based on dates
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!
2 Replies
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-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZUHi 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.
