How to relate tables in DAX without using relationships
User Rating: / 0
PoorBest 
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.

 

Read more...

 

  Tags: excel, dax, relationship, must read
 

Pyramid+PowerPivot