| How to relate tables in DAX without using relationships |
| Written by Marco Russo |
| Tuesday, 09 February 2010 22:23 |
|
PowerPivot supports only one type of relationship between two tables, which is the one-to-many relationship. You can define that a column in a table (the “many” side) corresponds to a lookup table through a column which is an identity column there (the “one” side). DAX provides support to follow this relationship through functions such as RELATED and RELATEDTABLE.
|
Author articles
- Grouping Transactions by Age of Customers in DAX
- LASTNONBLANK and FIRSTNONBLANK functions work with any column #dax #powerpivot #ssas #tabular
- SQL Down Under Podcast - Guest: Marco Russo
- Week-Based Time Intelligence in DAX
- The Right Version of Excel 2013 for using PowerPivot #powerpivot #excel
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- Learning PowerPivot and DAX
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
