- Rate Variance & Volume Variance
- Cost Per Headcount Measures & Analysis
- Variance Headcount Measures
- YoY Headcount Measures & Analysis
- Total Headcount Measures
- Average Headcount Measures
- Ending Headcount Measures
- Count of Months Measures
- Forecast Measures & Analysis
- Budget Measures & Analysis
- Quarter-to-Date Measures & Analysis
- Year-to-Date Measures & Analysis
- Variance Measures & Analysis
- YoY Finance Measures & Analysis
- Base Finance Measures & Analysis
- Extending the Data Model
- Understanding Data Tables
- Defining Data Types in the Data Model
- Loading Data into the Data Model
- Data Modeling Using Excel Power Pivot
- Data Modeling with DAX - Concepts
- Data Modeling with DAX - Overview
- Home
Data Modeling with DAX Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Total Headcount Measures
In the previous chapters, you have learnt how to create Count of Months measures and Average Headcount measures. You can use these measures to calculate the base Headcount Measures −
Actual Total Headcount
Budget Total Headcount
Forecast Total Headcount
In the subsequent chapters, you will learn how to use these base Headcount measures in other calculations such as YoY Headcount and Variance measures.
Creating Actual Total Headcount Measure
You can create Actual Total Headcount Measure as follows −
Actual Total Head Count:= Finance Data [Actual Average Headcount]* Finance Data [CountOfActualMonths]
Creating Budget Total Headcount Measure
You can create Budget Total Headcount Measure as follows −
Budget Total Headcount:= Finance Data [Budget Average Headcount]* Finance Data [CountOfBudgetMonths]
Creating Forecast Total Headcount Measure
You can create Forecast Total Headcount Measure as follows −
Forecast Total Headcount:= Finance Data [Forecast Average Headcount]* Finance Data [CountOfForecastMonths]
Advertisements