Database Reference
In-Depth Information
APPENDIX B
DAX Function Reference
Data Analysis Epressions (DAX), is the language used by both PowerPivot and
the Tabular mode of Analysis Services, and will be of great use during your
data analysis. This appendix contains a function reference.
uPdATed FunCTIon reFerenCe
Microsoft maintains an updated function reference at
http://msdn
DATE AND TIME FuNCTIoNS
Date and time functions, as listed in Table B-1, allow for the manipulation of
data stored in
datetime
formats.
TABle B1
Date and Time Functions
FuNCTIoN
DESCrIPTIoN
DATE(<
year
>, <
month
>, <
day
>)
Returns the specified date in date-
time format.
DATEVALUE(
date_text
)
Converts a date in the form of text to
a date in datetime format.
DAY(<
date
>)
Returns the day of the month, a num-
ber from
1
to
31
.
EDATE(<
start_date
>, <
months
>)
Returns the date that is the indicated
number of months before or after
the start date. Use
EDATE
to calculate
maturity dates or due dates that fall
on the same day of the month as the
date of issue.
