- Data Modeling with DAX Tutorial
- Home
- Data Modeling with DAX - Overview
- Data Modeling with DAX - Concepts
- Data Modeling Using Excel Power Pivot
- Loading Data into the Data Model
- Defining Data Types in the Data Model
- Understanding Data Tables
- Extending the Data Model
- Base Finance Measures & Analysis
- YoY Finance Measures & Analysis
- Variance Measures & Analysis
- Year-to-Date Measures & Analysis
- Quarter-to-Date Measures & Analysis
- Budget Measures & Analysis
- Forecast Measures & Analysis
- Count of Months Measures
- Ending Headcount Measures
- Average Headcount Measures
- Total Headcount Measures
- YoY Headcount Measures & Analysis
- Variance Headcount Measures
- Cost Per Headcount Measures & Analysis
- Rate Variance & Volume Variance
- Data Modeling with DAX Resources
- Quick Guide
- Useful Resources
- Discussion
Variance Headcount Measures
You can create the Variance Headcount measures based on the Headcount measures that you have created so far.
Creating Variance to Budget Ending Headcount Measure
You can create Variance to Budget Ending Headcount Measure as follows −
VTB Ending Head Count:= 'Finance Data'[Budget Ending Head Count]-'Finance Data'[Actual Ending Head Count]
Creating Variance to Budget Average Headcount Measure
You can create Variance to Budget Average Headcount Measure as follows −
VTB Average Head Count:= 'Finance Data'[Budget Average Headcount]-'Finance Data'[Actual Average Headcount
Creating Variance to Budget Total Headcount Measure
You can create Variance to Budget Total Headcount Measure as follows −
VTB Total Head Count:= 'Finance Data'[Budget Total Headcount]-'Finance Data'[Actual Total Head Count]
Creating Variance to Forecast Ending Headcount Measure
You can create Variance to Forecast Ending Headcount Measure as follows −
VTF Ending Head Count:= 'Finance Data'[Forecast Ending Head Count]-'Finance Data'[Actual Ending Head Count]
Creating Variance to Forecast Average Headcount Measure
You can create Variance to Forecast Average Headcount Measure as follows −
VTF Average Head Count:= 'Finance Data'[Forecast Average Headcount]-'Finance Data'[Actual Average Headcount]
Creating Variance to Forecast Total Headcount Measure
You can create Variance to Forecast Total Headcount Measure as follows −
VTF Total Head Count:= 'Finance Data'[Forecast Total Headcount]-'Finance Data'[Actual Total Head Count]
Creating Forecast Variance to Budget Ending Headcount Measure
You can create Forecast Variance to Budget Ending Headcount Measure as follows −
Forecast VTB Ending Head Count:= 'Finance Data'[Budget Ending Head Count]-'Finance Data'[Forecast Ending Head Count]
Creating Forecast Variance to Budget Average Headcount Measure
You can create Forecast Variance to Budget Average Headcount Measure as follows −
Forecast VTB Average Head Count:='Finance Data'[Budget Average Headcount]-'Finance Data'[Forecast Average Headcount]
Creating Forecast Variance to Budget Total Headcount Measure
You can create Forecast Variance to Budget Total Headcount Measure as follows −
Forecast VTB Total Head Count:= 'Finance Data'[Budget Total Headcount]-'Finance Data'[Forecast Total Headcount