Average Days Between Orders

[BrianJ]

@MAAbdullah47,

I’ve provided you a revised solution here:

Calculating the Average frequency of Days Between Orders

@MAAbdullah47, I have reworked the solution, eliminating the use of EARLIER by replacing it with a variable tracking the current row context. I have also converted all of the prior calculated columns to measures, and I believe the solution is now working properly per your requirements. [image] I’ve attached the revised solution file - please take a look and let me know if this meets your needs. Thanks. Brian DNA Forum – Average Days Between Solution2.pbix (445.8 KB)

Please let me know if this meets your needs. If necessary, we can continue the discussion in that thread, and I will close this one out.

• Brian