Data Modeling With Dax 简明教程

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]

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]

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]

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]

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]

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]

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]

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]

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]

Forecast VTB Total Head Count:= 'Finance Data'[Budget Total Headcount]-'Finance Data'[Forecast Total Headcount