sum of target hours when choosing months from slicer

[s-mawass]

I Have this Data, and I Know that each employee should complete (100) hours per full month

I need to get the sum of Target Hours for each employee when selecting Months from slicer 
-Notice that there is some employees started after the first day in Month 
@dax

[v-luwang-msft]

Hi @s-mawass ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft · Accepted solution]

Hi @s-mawass ,

Based on the data you provided, the number of days * 24 equals the total number of hours, and using the slicer, you can filter.

If question still not solved ,could you pls share your sample data ,and expected output.

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

Best Regards

Lucien

[PaulDBrown]

Create a date table linked to the start date and use the month field as the slicer and a simple SUM of the hours.