Forum Discussion
DAX Formula Help
- 3 years ago
maruthisp , You can follow the HR analytics pattern
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
maruthisp , You can follow the HR analytics pattern
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
- maruthisp1 year ago
Super User
amitchandak Appreciate for sharing the links and for the solution. It helped to calculate some of the measures on the future date with INACTIVE relationship definition in Data Model and use the USERELATIONSHIP function to calculate on the INACTIVE relationships for the measures.