Forum Discussion
Need help on below scenario
I got data having 2 columns (Product and Age) as below and calculate valid event for each product as shown in "Valid event".
I have tried "Earlier" & Ranking function but could not able get to the full result. Please share your thoughts.
| Product | Rank | Age | Valid event | |
| A | 1 | 0 | 1 | Default valid event |
| A | 2 | 9 | 1 | >= 6 gap from first valid event |
| A | 3 | 10 | ||
| A | 4 | 12 | ||
| A | 5 | 16 | 1 | >= 6 gap from second valid event |
| A | 6 | 19 | ||
| A | 7 | 22 | 1 | >= 6 gap from Third valid event |
| A | 8 | 29 | 1 | >= 6 gap from forth valid event |
| A | 9 | 30 | ||
| A | 10 | 36 | 1 | >= 6 gap from five valid event |
| B | 1 | 0 | 1 | Default valid event |
| B | 2 | 1 | ||
| B | 3 | 2 | ||
| B | 4 | 4 | ||
| B | 5 | 6 | 1 | >= 6 gap from first valid event |
| B | 6 | 8 | ||
| B | 7 | 25 | 1 | >= 6 gap from second valid event |
2 Replies
Hi Anonymous ,
What makes an event a default one? Age = 0? Do you have dates?
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
Hi ERD
Very first event/age=0/rank=1 all these criteria makes default event. Each event valid event counted as 1.
Using earlier function/ Variable able to identify >=6 age. but in some cases like below 16 is valid event and next 22 is valid event but in power bi I could not able to figure how to conditionly earlier valid record with current if corrent row didn't satisfy the >=6 condition.
