Database Reference
In-Depth Information
ating the formula, you may find this frustrating. Use the
Tab
key instead
while writing formulas to avoid this issue.
4. Once you have completed the formula, you should rename the column to
Full Name
.
There's more…
In the
Modeling the data
recipe, I mentioned that data can be related using calcu-
lated columns. This is important while working with data from different sources where
the data may not be naturally related. You can resolve this issue by using calculated
columns which will support relationships. A quick example would be bringing in an
external ZIP code reference table named
ZipCode
. If your
Address
table had the
ZIP+4 format, (55778-4224) and the new
ZipCode
table only had ZIP codes without
the "+4" (55778), you could create a calculated column on the
Address
table to strip
those extra five characters off (
=Right([Address].[ZipCode],5)
). Now, a re-
lationship is possible between the new column in
Address
and the existing column
in
ZipCode
.
See also
• Check out more options for creating calculated columns in
Chapter 10
,
DAX
Calculations and Queries
, in the section on DAX formulas.
Search WWH ::
Custom Search