Forum Discussion
Help getting sum in specific date
Hi,
I have data that has the Planned effor by day and a specific iteration start/end date. I want to get the totol effort on the start iteration start date and end date. the current chart looks like this. Its a burn down char.
So I want to have the total effort for the start date of iteration that should be 107 and the total effort of the end date of the iteration that is 64. I tried this but got 6.44k. The Chart does do it correctly but I want measure so I can then do other calculations based on these values.
Anonymous, refer if these ways can help
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzMPower 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
1 Reply
- amitchandakSuper User
Anonymous, refer if these ways can help
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzMPower 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