DAX (Data Analysis eXpressions) introduces the functions RELATED and RELATEDTABLE for following & navigating through the chain of relationships in Power BI, Power Pivot & SSAS Tabular and It is used to retrieve related data from another table. Both of these functions are more powerful than VLOOKUP in Excel in a couple of ways. First, … Continue reading The Magic of RELATED & RELATEDTABLE functions in DAX
Traditionally, business intelligence projects tend to use a star (Kimball) or snowflake(Inmon) schema; a design approach that has become the de facto design standard for data warehouses and cubes over the last few decades. Below is an example of a star schema: The center of the star is called the fact table. It describes the … Continue reading How do relationships work in Power BI?