Calculating monthly average with start date & end date

[Anonymous]

I need to calculate the number of days taken to complete a request, plus what is the monthly average based on the complexity of the request. 

Basically would like to read the month in the start date & end date then if it was completed in the same month report it as completed and plus its complexity as well.

Below is an example of how my data looks. 

Results I want : 

2 medium, 1 Low & 1 high was completed in July

Person	Complexity	Start Date	End date
AB	Medium	02/07/2020 11:30:00 AM	12/07/2020 14:00:00 PM
AB	Medium	03/07/2020 11:00:00 AM	09/07/2020 15:30:00 AM
TG	High	15/07/2020 12:30:00 PM	31/07/202011:22:00 AM
NA	Low	10/07/2020 09:00:00 AM	12/07/2020 16:01:00 AM
XY	Low	31/07/2020 09:00:00 AM	02/08/2020 14:05:00 PM
OP	High	02/08/2020 09:00:00 AM	21/08/2020 15:48:00 PM
OP	Medium	02/08/2020 12:04:00 PM	15/08/2020 5:05:00 PM

[Anonymous]

Thank you everyone for your suggestions. 

@Greg_Deckler I used your solution and it has worked. Thank you 

[AllisonKennedy]

@Anonymous 

Please use @Greg_Deckler  's solution if you want to count XY Low in August, but are you saying that you only want to count the row if the start date and end date are in the same month? 

If that's the case, please try this measure: 

Total Persons = COUNTAX(FILTER('Table', MONTH('Table'[Start Date]) = MONTH('Table'[End date])), 'Table'[Person])

See attached pbix file below signature for setup on how to get this by month. 

I do also recommend having a DimDate table for this. https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html

[amitchandak]

@Anonymous , You can diff like this

datediff([start date], [end date], day) // you can also use hour, minute etc

for the month from the date you can use

month([start date])

format([start date], "MMM-YYYY") //Month Year

you can use above to create a logic of your choice

[Greg_Deckler · Accepted solution]

@Anonymous - Create  a column:

Month = FORMAT([End date],"mmmm")

Create another column

MonthSort = MONTH([End date])

For Month, specify a sort by column of MonthSort.

Now create a visual with Month, Complexity and COUNT of any column or create a COUNTROWS measure.