Forum Discussion
akhassim
2 years agoNew Member
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 ...
amitchandak
2 years agoSuper User
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/fvgcx8QLqZU
Window 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