Need help on Measure

[arunmathew12345]

Hi, Please can you help. I need to produce the result in 'Report' from the data on the left

OrderDate	ClosedDate
20/11/2020	20/11/2020		Report
20/11/2020	23/11/2020		Date	Outstanding Orders
20/11/2020	23/11/2020		20/11/2020	4	(5 orders - 1 closed)
20/11/2020	22/11/2020		21/11/2020	8	(5 orders + 4 outstanding on  20/11 - 1 closed)
20/11/2020	27/11/2020		22/11/2020	14	(7 orders + 8 outstanding from 21/11 - 3 closed + 2 Not complete)
21/11/2020	23/11/2020
21/11/2020	24/11/2020
21/11/2020	29/11/2020		Blank = Not Complete
21/11/2020	21/11/2020
21/11/2020	28/11/2020
22/11/2020
22/11/2020
22/11/2020	22/11/2020
22/11/2020	24/11/2020
22/11/2020	28/11/2020
22/11/2020	24/11/2020
22/11/2020	22/11/2020

[arunmathew12345]

Thank you so much @amitchandak  . I have 2 questions for you

1. How can I add a monthly average to this?

2. Do you offer 1:1 coaching on Pbi?

[amitchandak · Accepted solution]

@arunmathew12345 , refer by blog hr, seem, similar current employee, 

https://www.youtube.com/watch?v=e6Y-l_JtCq4

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[arunmathew12345]

Hi Amit, 

Is there a way to find average of current employee column in your table between given set of dates?