Forum Discussion
undefined
I have a bar graph. On the x axis is my date (MMM yyyy) and on the y-axis is Committed, Planned, Actual and Forecast. Need to add cumulative lines for Committed, Planned, Actual (only to date), with Forecast commencing from the end of the Actual. Please advise how I do this.
1 Reply
akhassim , based on what I got. Approach of HR analytics should help
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/fvgcx8QLqZUWindow function can help for cumulative
Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f
