Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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. Styles 2 & 4 would need identified as have a break in their buy pattern.
I would then make a KPI that 2 out of the 4 styles don't have consecutive buys per our buy calendar. 50% of the styles are not bought consectutively. Newer user, so I'm sure someone out there has the answer!
Solved! Go to Solution.
Hi,
You may download my MS Excel file from here. The same file can be imported into PBI desktop as well.
Hi,
You may download my revised PBI file from here.
Hope this helps.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |