Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
hi team,
i have too create a cohort analysis.
my variable is number of book seel each books. some of these books can have a downgrade or a upgrade.
the process of writing and publish the book can take until a year.
also i want for instance for those books sold in january 2020, what was the retention each month.
any tips or help please
Hi @julien13b1 ,
I'm not clear about your requirement. Could you please provide some sample data(exclude sensitive data) and your expected result with calculation logic and specific examples? Thank you.
Just for example:
Sample data:
| Col1 | xxx | Colxx |
| aa | .. | 11 |
| bb | .. | 22 |
Expected result(include visual setting, calculation logic and correct values etc.)
I found some blogs about cohort analysis, you can watch or read them. Hope they can help you.
DAX for Power BI - Easy Cohort Analysis
Time Based Cohort Analysis – Setting Up Your Data Models In Power BI
Best Regards
@julien13b1 Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490...
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 130 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |