Join 400,000+ professionals in our courses here https://link.xelplus.com/ytdallcou...

Dive deep into the world of data modeling with our comprehensive guide on managing manytoone relationships in Excel and Power BI. Perfect for intermediate to advanced users, this video is packed with practical examples and advanced DAX techniques.

⬇ DOWNLOAD the workbook here: https://pages.xelplus.com/manytoone...

What You'll Discover:
▪ Essentials of ManytoOne Relationships: Learn the fundamentals and their application in data models.
▪ Practical Excel & Power BI Strategies: Gain insights on how to effectively navigate these relationships in both platforms.

Get access to the full course here: https://www.xelplus.com/course/excel...

Techniques Explored:
▪ Distinct Count Case Study: A stepbystep guide on counting distinct data entries.
▪ DAX Formulas Unveiled: Master the use of CALCULATE and CROSSFILTER for dynamic data analysis.
▪ Alternatives & Best Practices: Discover different approaches and when to use them for optimal results.

Relationships in Microsoft Power BI and Power Pivot give us the ability to report on fields from multiple tables in the data model. The most common type of relationship used in data models is a OnetoMany Relationship. But sometimes you have to go from the Many side to the OneSide of the Relationship. I'll show you 3 different solutions you can apply in DAX. You can use these techniques in Excel Power Pivot and in Power BI as well. The first technique takes you through the DAX CALCULATE function and shows a trick you can use to get the filter flow the other way. I'll also demonstrate how the many to one side calculation works by breaking down the measure in simpler calculation steps so you can visualize and understand the process and how DAX performs the final calculation.

My Online Excel Courses ► https://www.xelplus.com/courses/

00:00 Calculate with ManyOne Relationships
00:22 ManytoOne Relationships In data models
02:11 The Wrong Approach
03:41 Solution 1: Using DAX CALCULATE
06:36 Solution 2: Adding a Column On ManySide RELATED
07:36 Solution 3: Using CROSSFILTER
09:28 Wrap Up

LINKS to related videos:
Excel Productivity for Lazy (but Smart) People:    • Excel Productivity for Lazy (but Smar...  
DAX CALCULATE Function Made Easy to Understand:    • DAX CALCULATE Function Made Easy to U...  

➡ Join this channel to get access to perks:    / @leilagharani  

☕ Get the Official XelPlus MERCH: https://xelplus.creatorspring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/coursequiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram:   / lgharani  
LinkedIn:   / xelplus  

This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel #powerbi #dax