Total Headcount Measures


Advertisements


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
E-Books Store