Target change during the year

JBESRI 

To measure the targets over the period of their target and combine them, you can follow these steps in Power BI:

1. **Create a Calendar Table**: If you haven't already, create a calendar table in Power BI that spans the period of your targets. This table will have a date column that you can use to filter and aggregate data over time.

2. **Calculate Total Hours for Each Employee and Work Type**: Write DAX measures to calculate the total hours worked by each employee for each work type. Here's an example:

```DAX
Total Hours = SUM('YourTable'[Hours])
```

Replace `'YourTable'` with the name of your table containing the work hours data.

3. **Calculate Target Hours for Each Employee and Work Type**: Write DAX measures to calculate the target hours for each employee and work type based on the target percentages. Here's an example:

```DAX
Target Hours =
VAR TargetPercentage = SELECTEDVALUE('Targets'[Target Percentage])
RETURN
TargetPercentage * [Total Hours]
```

Replace `'Targets'` with the name of your table containing the target percentages.

4. **Compare Actual vs. Target**: Write DAX measures to compare the actual hours worked to the target hours for each employee and work type. Here's an example:

```DAX
Actual vs. Target =
VAR ActualHours = [Total Hours]
VAR TargetHours = [Target Hours]
RETURN
IF(ActualHours >= TargetHours, "Met", "Not Met")
```

5. **Visualize the Data**: Create visuals in Power BI, such as tables or charts, to visualize the actual vs. target hours for each employee and work type over time. You can use slicers or filters to analyze the data for specific time periods or employees.

By following these steps, you can effectively measure the targets over the period of their target and combine them in Power BI. Adjust the DAX measures and visuals as needed to fit your specific requirements and data model.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!