Hours allocated and spent

[powerflanker]

Hi,

I have a need to calculate employee's hours spent on work and not spent. I have two speadsheets :

Table 1 - Has employee Information

Employee ID	Allocated Start Date	Allocated End Date
1111111	3-May-2022	30-Sep-2022
2222222	5-Jun-2022	30-Sep-2022

I have another sheet which has time card info (per day per employee) - all filled dates from Feb 2022 onwards till current. 

Table 2

Employee ID	Timecard filled date	Hours filled
1111111	1-may-2022	8
...	...	..

I need a monthly report like the below only for all employees Part of table 1 and between Allocated Start Date and Allocated End Date

Employee ID	Month	# of days timecard filled	# of days timecard missed

I have been able to load the excel sheets into datasets (table 1 and Table 2). But as I am new to Power Bi, I dont know how to get to the end result. Any help will be high appreciated. Thanks

[tamerj1]

Hi @powerflanker 
Can you share sample of few rows of both tables relevant enough to generate a sample file for you? Thank you