Hello, my requirement is to calculate the average between two dates of issues that have prep complete date falling under the current month.
If there are three issues that have a date field called “Prep Complete date” which are October 10, 2021 ; October 11, 2021 ; October 12, 2021 then I want to calculate the average between the dates “Start Date” & “Complete Date” fields.
I was using this below formula which is calculating the average between two dates. I’m not sure how to include the above condition.
Avg( Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]), ([Measures].[Issues created], [Status].[done])>0 ), (DateDiffWorkdays( [Issue].CurrentMember.Getdate("Start Date"), [Issue].CurrentMember.GetDate("Complete Date") )) )