Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a challenge, I need to create a Cohort Analysis for Saas company.
There are two tables:
Both linked by a subscription_id.
In one table, there is the register_date (dd/mm/YYYY) of each user and in the other table, there is the subscription_start_date (dd/mm/YYYY) that is the date that the user starts paying (not all users start paying).
Right now I have this table:
And I need to create this table two tables:
- Table one where:
In the second table is the same information just getting the percentage (paying users / users registers) ex:
- Ago-19 and month 3: 138/1214=11,37%
Many thanks for your help, I really appreciated
Best
Solved! Go to Solution.
@diegogoya86 , refer if these can help
https://finance-bi.com/power-bi-cohort-analysis/
http://funbiworld.com/2019-12-02-cohort-analysis/
https://www.youtube.com/watch?v=tuk1CrigTSI
SaaS Cohort Analysis: Evaluating Customer Behavior and Engagement Over Time SaaS cohort analysis is a method of evaluating customer behavior and engagement over time. This analysis can be used to improve customer retention or to identify areas where customers are struggling with your app.
Greeting,
Rachel Gomez
Hi @diegogoya86,
I think you can create a new table to extract all column types with the corresponding index, then you can create a matrix table with use new table column and row table rows categories.
After these steps, you can add two measures: one of them uses the current data label of row/column to lookup and summary values; the other one checks the previous measure result and setting up conditional color formatting based on 'summary value' measure.
If you are confused about coding formula, please share some dummy data to test.
Regards,
Xiaoxin Sheng
Thank you very much, I try to build it and if I have doubts I comment.
greetings
Diego as it goes.
Were you able to get the Cohort out?
I have the same problem. 2 tables one where is the date of the registration of the client and another table with the date of the use that gives to the application.
I want to cohort the usage according to your registration date.
Stay tuned.. Best regards!
@diegogoya86 , refer if these can help
https://finance-bi.com/power-bi-cohort-analysis/
http://funbiworld.com/2019-12-02-cohort-analysis/
https://www.youtube.com/watch?v=tuk1CrigTSI
@diegogoya86 Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |