Skip to main content
Showing results for 
Search instead for 
Did you mean: 

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.

Not applicable

User Cohort Analysis

Hi everyone,

I really want to create a cohort analysis for new users in Power BI (like the below example in Excel). So every month we get new users and I want to know how many stay a couple of months later. For example, out of the 38 new users in Jan-20, only 25 users stayed two months later. 


I have a table with all the users for the last 20 months. In this table, I have both Start_date and Last_date. But I need help with the DAX function and I hope someone can help 🙂





@Anonymous ,


I have done something similar, in order to see the # people lost and # people gained that make up a month over month change in people. I used this SQLBI example to get mine working:


Hope this helps!

Zoe Douglas (DataZoe)

Follow me on LinkedIn at
See my reports and blog at

Super User
Super User
Not applicable

Hi @amitchandak 

I've seen these links, but all of them are on customers, so mine is quite different. I want to look at two date columns instead of looking at if the customer appears again. 

I have a user_table with 4 columns (User_ID, Name, Start_Date and End_Date). If the user is still member than End_Date is null. Start_date is the y-axis as shown in the example from Excel and to the x-axis, I created the below table:







Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.