Uploaded August 2026 | Updated September 2026, 2 weeks ago

---

I’m running a limited-time offer where you can get 2 Power BI dashboards for the price of 1 - goodly.co.in/power-bi-dashboard-bundle-50-off

📌If your company needs help building professional Power BI reports like this, fill out this form and our team will get in touch - https://in.bigin.online/org60031607649/forms/book-a-call


In this video, I build a Cohort Analysis Dashboard in Power BI and explain how the logic works from the ground up.

We start by identifying when each customer made their first purchase, then calculate how many months have passed since that first purchase. From there, we build the cohort matrix to see how many customers were acquired in each month and how many of them returned in the following months. I also show how to calculate the customer retention percentage using DAX.

This kind of cohort analysis is especially useful for tracking customer retention, churn, repeat purchases, and customer behaviour in SaaS, e-commerce, marketing, and other subscription or repeat-purchase businesses.



===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book

✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?

✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi

✔️ Power Query Course -
products.goodly.co.in/learn-power-query

✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel


===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨‍🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting
Download the Practice file ⬇️ - goodly-6v06kb.subscribepage.io


===== CHAPTERS =====
0:00 Understanding Cohort Analytics Basics
1:00 Exploring the Final Dashboard Features
4:02 Building the Core Cohort Matrix
7:06 Creating the Cohort Start Period
11:17 Calculating Retention Percentages


===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com


===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!