MDX - Counting Consecutive Days
A recent blog post (here) questioned a method for returning the most consecutive days that a customer has brought product for. For example, given a particular customer what's the largest continuous date span of their purchases? More realistically, a business question may be 'what are the customers who purchase for more than 5 days in a row'?
Read more...