Forum Discussion

jgray72's avatar
jgray72
Helper II
7 years ago
Solved

How Can I Count Breaks in a Pattern?

Hi - in the below data set, I want to count the number of styles that have a break in their buying pattern.  For example, I want to know that two out of the 4 styles don't have consecutive buys.  Sty...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    You may download my MS Excel file from here.  The same file can be imported into PBI desktop as well.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    You may download my revised PBI file from here.

     

    Hope this helps.

     

jgray72's avatar
jgray72
Helper II
7 years ago

Thank you so much!  It works!!!  

 

Appreciate your help.

 

Julie

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

You are welcome.