Trailing 5 day average of resolution

[Anonymous]

I have date that looks like the following:

ID	Created Date	Resolved Date
1	01/02/21	01/03/21
2	01/02/21	01/04/21
3	01/03/21	01/03/21
4	01/05/21	(blank)
5	01/05/21	01/05/21

I need to calculate the trailing 5 day daily average for items resolved. I tried the following but it's not returning the correct numbers based on manual calculations:

measure = Calculate(Countrows('Table'),DATESINPERIOD('Table[Resolved Date]', LASTDATE('Table[Resolved Date]'),-5,DAY))

I have another table being used as a date reference table that just contains a row for every date that exists in the data. I would need to use this as the dimension to calculate this on. Any help on this would be great.

[Jihwan_Kim]

Hi, @Anonymous 

Please correct me if I wrongly understand your question.

I assume that you want to know the 5days moving average for items in the process?

Please check the below picture if that is what you are looking for.

the sample pbix file's link is down below, and you can see all measures in the file.

https://www.dropbox.com/s/qsoqv29jx24g54z/mallen82.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.