title: Count maximum sequel of null values - mdx query
body: <p>I want to create a member based on this problem</p>
  
  <p>I have a Product A being sold
  I want to find the largest range of consecutive days without sale</p>
  
  <p>example:</p>
  
  <p>days 1,2,3 the product not sale, after that,it sold for 15 consecutive days, at 19th day it didnt sell for 2 days and after that it sold every day until the end of the month</p>
  
  <p>so my maximum days without sale was 3</p>