cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Prash1283
Regular Visitor

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.

ProductRankAgeValid event 
A101Default valid event
A291>= 6 gap from first valid event
A310  
A412  
A5161>= 6 gap from second valid event
A619  
A7221>= 6 gap from Third valid event
A8291>= 6 gap from forth valid event
A930  
A10361>= 6 gap from five valid event
B101Default valid event
B21  
B32  
B44  
B561>= 6 gap from first valid event
B68  
B7251>= 6 gap from second valid event
2 REPLIES 2
ERD
Memorable Member
Memorable Member

Hi @Prash1283 ,

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.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Stand with Ukraine!

Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/

Thank you!

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.

 

Prash1283_0-1633425640124.png

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors