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 distributed among the cohorts based on the number of total requests (requested_articles) per month (since 2022).
I hope someone can help me 🙂
2 Replies
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Sorry. 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
