Forum Discussion
Creating a retention table
Thank you for the quick reply!
What I'm missing in what you sent is - I don't see the retention data. for example, when you chose capability A, in 1/1/24 - you have a 100% at the beggining on week 1 as expected, but then on week 2, 3 and 4 I'd also expect to see the retention % ( how many unique companies are still using it ).
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.
What I meant was - I was expecting to see an output like this, where you actually see the retention by week: