Published on Aug 16, 2021:
In this video, we will learn to join two fact tables using a common dimension table in Power BI.
In the previous video, we learnt when DAX treatas function does not show the correct numbers. What could be the reason for the numbers not reconciling.
Previous Video: youtu.be/ezX_VaUv2QY
SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!
youtube.com/channel/UCYYHFZpm5GbaOmQKDNSTGLw
Download M Query code:
bit.ly/3kJwUUq
Our Playists:
Extract Load and Transform data using Power Query: bit.ly/3orLRf4
Enhance Power BI Data model using DAX: bit.ly/2GbTENc
Python and Power BI: bit.ly/2EajdNc
Getting Started with AWS: bit.ly/2PgSCQX
SQL Playlist : goo.gl/PS5Ep6
DAX PlayList : goo.gl/S4W41D
Power BI PlayList: goo.gl/dXxvnB
Power Query Playlist: goo.gl/5QS7P4
Getting Started with Power BI: goo.gl/GHakLZ
Getting Started with Python: goo.gl/n24P3w
Data Science With Python: goo.gl/PeYCR5
Power BI service: tiny.cc/sjekmz
Data Modelling with Power BI: tinyurl.com/8b4srjrm
ABOUT DAGDOO:
Website:
Home Page: dagdoo.org/
Power BI Tutorials: dagdoo.org/excel-learning/tutorial-power-bi-desktop/
Questions? Comments and SUGESTIONS? You will find me here:
Twitter: @dagdooe
Category: Science & Technology
License: Standard YouTube License
- Join Two Fact Tables using a common dimension table Power BI ( Download)
- Handling MULTIPLE fact tables in Power BI ( Download)
- Power BI – Multiple Fact Tables ( Download)
- Easy PBI - Connecting multiple fact tables with a date table in Power Bi - Beginner Tutorial ( Download)
- Multiple Fact Tables and Multiple Date Tables Power BI ( Download)
- Working with multiple Fact Tables in power bi ( Download)
- The Dimensional Dilemma and Power BI ( Download)
- Solution for Two Fact Tables: Power Query or DAX formulas or Worksheet Formulas 365 MECS Class 18 ( Download)
- How to Join Two Tables on Multiple columns in Power BI | Join Two Tables on COMPOSITE KEY |BI Tricks ( Download)
- Power BI Modelling Part 5 - Handling Multiple Fact Tables | Power BI Tutorial (49/50) ( Download)
- Number of Fact tables in a data model Power BI ( Download)
- Power BI - Power Query - Create Dimension or Lookup Table ( Download)
- Highly Denormalised Fact Tables Power BI ( Download)
- Building relationships between tables when both have duplicates ( Download)
- Creating new Power BI Table by Combining Distinct Values from Multiple Tables ( Download)
