DAX Calculations and Queries - SQL Server Analysis Services 2012 Cube Development - page 371

2. Place the cursor in any cell in this new column. Start typing an expression
with an equal to sign, then type the letter R . Notice that a drop-down list
below the formula box displays functions and objects that match the text you
type. Type or select the word RELATED . When you have the object or func-
tion name selected in the drop-down list, press the Tab key to select it.
Note
The RELATED function accepts one argument, which is the table and
column reference for any table related to the current table through a dir-
ect or indirect relationship.
3. You can complete the expression by selecting items in the drop-down list as
you type.
Note
You should learn to work with this feature as it can help avoid mistyped
object names and spelling errors. There are caveats to the autocomple-
tion feature that can lead to syntax errors unless you learn to work within
its capabilities and outside of its limitations. I suspect that as the product
matures in future versions, we will see some fine-tuning and optimization.
Personally, I find this feature helpful most of the time but I have learned
to anticipate certain patterns of behavior. In particular, if an object name
(such as a table or column name) has already been entered into an ex-
pression and you use autocompletion to select a different object, the tool
will replace the object reference but add redundant quote marks or brack-
et characters. These can be hard to spot at a glance and will result in a
syntax error. Another rather unfortunate feature of the tool is that when a
syntax error is introduced to an expression, especially when the expres-
sion is long and complex, after reporting an error, it will revert to a previ-
ous state and you will lose changes. While making changes, I've learned
to copy the entire expression to the clipboard before pressing the Enter
key. This way, I can paste the expression, make corrections, and then