Forum Discussion
Cohort Analysis
Hi all, I'm still fairly new to using Power BI and am failing to do a cohort analysis. I have created a table with the corresponding cohorts. Now I want to find out how many customers are ...
Sorry. So here are some sample data:
| update_created | customer_id | requested_articles |
| 3/31/2023 2:00 | 5549 | 969 |
| 3/30/2023 13:00 | 4672 | 169 |
| 3/27/2023 15:30 | 4391 | 66 |
| 3/27/2023 14:00 | 5663 | 14123 |
| 3/27/2023 14:00 | 2879 | 67924 |
| 3/27/2023 1:00 | 5225 | 85898 |
| 10/31/2022 2:00 | 2946 | 9085 |
| 10/31/2022 1:00 | 3305 | 3971 |
The Cohort Overview:
| CohortName | MinSumRequests | MaxSumRequests |
| <5.000 | 0 | 5000 |
| 5.000-50.000 | 5001 | 50000 |
| 50.000-100.000 | 50001 | 100000 |
| 100.000-200.000 | 100001 | 200000 |
| 200.000-500.000 | 200001 | 500000 |
| 500.000-1.000.000 | 500001 | 1000000 |
Based on the sample data the outcome that I need would look like this:
| Month / Year | CohortName | Sum of Customers |
| March / 2023 | <5.000 | 3 |
| March / 2023 | 5.000-50.000 | 1 |
| March / 2023 | 50.000-100.000 | 2 |
| March / 2023 | 100.000-200.000 | 0 |
| March / 2023 | 200.000-500.000 | 0 |
| March / 2023 | 500.000-1.000.000 | 0 |