Power BI Practice Intro ROUND #6 I Analyze your data by COHORT

Topline numbers are often hiding underlying trends. It maybe a good idea to analyze your data by cohort. In this Power BI Practice Round Intro I explain the details of this round- you will have to break apart the customers (create cohorts) based on the year of first purchase.

Requirements:
- Create an area chart that shows total sales over time by year and quarter
- Add a measure that calculates the total sales for new customers
While there does not seem to be a problem with the top level sales, the sales for new customers is going down. To get more insights you have to break down revenue by different customer cohorts.
- Create a calculated column that returns the first year of purchase.
- Create an area chart that shows total sales over time by year and quarter
- Insert a 100% stacked column chart. Show years on the axis, total sales on values, and year of first order on the legend
- Create an area chart that shows total sales over time by year and quarter
- Create another cohort based on the Number of Orders per Customer. Do this using a calculated column
- Insert a stacked column chart with Number of Orders per Customers on the x-axis and the distinct count of customers on values. Place the year of first order on the legend.

Share your approach, questions, feedback below or on Twitter using the hashtag #PowerBIPractice and tag @HowToPowerBI

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[HowtoPowerBI]

Let us know how difficult you find this challenge!