Forum Discussion
Days of Service - Calculation
Try the solutions in the link.
https://community.powerbi.com/t5/Desktop/Creating-groups-based-on-numbers/m-p/513856
Ther's one using M and the other using DAX.
Note that you should have Duration column (either in Query or in model).
Hi Anonymous,
Since there are hire date and termination date columns in table, you can create a calculated column via DATEDIFF to calculate the total days of service for each employee. Then, you can refer to the solutions in above link to group these results.
Regards,
Yuliana Gu
Microsoft EmployeeHi Anonymous,
Since there are hire date and termination date columns in table, you can create a calculated column via DATEDIFF to calculate the total days of service for each employee. Then, you can refer to the solutions in above link to group these results.
Regards,
Yuliana Gu
Thank You! I created a DATEDIFF Column and created those variations through the SWITCH Statement