Forum Discussion

Eyal_H's avatar
Eyal_H
Regular Visitor
1 year ago

Creating a retention table

I have this table as seen in the picture.  I'm trying to create a retention table, with the end result being somewhat similar to the example I sent in the second picture. In my case what I'm trying...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Eyal_H ,

 

Sorry for that the information you have provided is not making the problem clear to me.  Is that what you mean? According to my test data, company 1 was there in the first week and company 1 was still there in the second week, so the survival rate is 100%. If that's what you mean, you just need to place the fields as shown below.

 

 

If I have misunderstood you, please provide example data, logic and expected results.

 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Neeko Tang

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

Eyal_H's avatar
Eyal_H
Regular Visitor
1 year ago

What I meant was - I was expecting to see an output like this, where you actually see the retention by week: