Power BI Practice Intro ROUND #9 I COMBINE TEXT VALUES using DAX

Time to practice your DAX skills! In Power BI you can often approach something in many different ways. In this challenge we are creating the same visual as in round 8, but instead of using Power Query you have to solve it using DAX. The main challenge in the Power BI Practice Round - how to combine text values using dax or otherwise, concatenate text values to summarize your data. Then we need to figure out how to keep only the top 3 ranked. The data for this challenge is a template for hour tracking by employees for different projects.

Requirements:
- Add a measure that shows the concatenated list of the top 3 people involved per project (based on total hours worked).
- Create a clustered bar chart with project on the axis, IsInTop3 vs Other the legend, hours worked on values and on the tooltip Most Involved Employees.

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