Forum Discussion
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...
Hi,
You may download my MS Excel file from here. The same file can be imported into PBI desktop as well.
Hi,
Is this your expected result?
Hi Ashish - that is indeed the expected result. How were you able to achieve it?
Thanks!
Julie
Hi,
You may download my MS Excel file from here. The same file can be imported into PBI desktop as well.
Thanks so much, it worked!
Hi - I played with this formula some more and it doesn't work. It doesn't tell the difference between a buying pattern without breaks vs. one that has breaks. I coverted it to DAX and it just gives the number of buys that aren't one time buys. Still working it, as the solution is proving to be evasive!
183012 should not show up below as having intermittent purchases.