Power Bi

[Gurukiran003]

I have two table one Task Table and 2nd one is empolyee leave taken Table

in Task table it show the name of the empolyee who working on which task and also its show start date and end date of project along with overal work hours, 

here we need to find average of work hours example if he worked from 1-jan to 5- jan 2020 then number of days is "5 days" then overal work hour is 15 then average is 15/5=3( only possible if that person is not on leave during these 5days) , incase he to a leave on 1-jan-2020 and 4-jan-2020 then out 5days he was absent for 2days that means he worked only 3days i.e 2-jan-2020,3-jan-2020 and 5-jan-2020, now the average work is 15/3=5, that value i have to show in date wise i.e 

1-jan-2020 = leave has to show 2-jan-2020 = 5 , 3-jan-202 =5 , 4-jan-2020 =Leave and 5-jan-2020 = 5, the value has to show in leave

 

tracker

[Ashish_Mathur]

Hi,

"if he worked from 1-jan to 5- jan 2020 then number of days is "5 days" then overal work hour is 15".  How did you calculated the overall hours to be 15 over 5 days?

[Gurukiran003]

there is a column effort it gives overal working hour we need distribute it as i mentioned above.