Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 ...
DAX
EARLIER
Iterator
ranking
ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
5 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.