Human resources software is one of the most common modules used by any organization. While it is simple to understand, it contains a few challenging analytical calculations. One such calculation is Active employees. In this article, we will not only discuss how can we get that, but we will also showcase hire and termination calculation on the same Date table. One more calculation which we cover here: One measure to provide last period calculation for both month and year.