SQL Analysis Services Keywords Reference

This section provides a reference to the keywords used in SQL Analysis Services, including MDX (Multidimensional Expressions) and DAX (Data Analysis Expressions).

Keywords by Category

MDX Keywords

Keywords specific to the Multidimensional Expressions (MDX) language, used for querying and manipulating multidimensional data.

  • ADD MEMBER
  • ALL
  • AND
  • AS
  • BACK_COLOR
  • BEGIN
  • BODY
  • BREAK
  • CELL_ORDINAL
  • CHOOSE
  • COLOR
  • COLUMNS
  • CREATE
  • CURRENCY
  • DATA
  • DATABASE
  • DATE
  • DAY
  • DECIMAL
  • DELETE
  • DIMENSION
  • DISTINCT
  • DRILLDOWN
  • DRILLTHROUGH
  • EDIT
  • ELSE
  • END
  • EXCEPT
  • EXECUTE
  • EXISTS
  • EXP
  • FAILURE
  • FALSE
  • FILTER
  • FIRST_CHILD
  • FIRST_SIBLING
  • FONT_NAME
  • FONT_SIZE
  • FONT_STYLE
  • FONT_UNDERLINE
  • FONT_WEIGHT
  • FOR
  • FORMAT_STRING
  • FROM
  • FUNCTION
  • GROUPING
  • HEAD
  • HIERARCHIZE
  • HOUR
  • IF
  • IN
  • INDEX
  • INDICATOR
  • INNER
  • INSERT
  • INTERSECT
  • IS
  • ITEM
  • KEY
  • KOREAN
  • LAST_CHILD
  • LAST_SIBLING
  • LANGUAGE
  • LEFT
  • LEVEL
  • LINK
  • LIST
  • LOAD
  • LOCALIZATION
  • LOGICAL
  • LOGICAL_AND
  • LOGICAL_OR
  • MEMBER
  • MEMBER_KEY
  • MEMBER_NAME
  • MEMBER_UNIQUE_NAME
  • MEASURE
  • METADATA
  • MID
  • MINUTE
  • MODEL
  • MONTH
  • NAVIGATE
  • NEXT
  • NON_EMPTY
  • NOT
  • NULL
  • NUMERIC
  • OBJECT
  • ON
  • OPEN
  • OR
  • ORDER
  • ORDINAL
  • PARENT
  • PARTITION
  • PASSWORD
  • PASSWORD_ENCRYPTED
  • PASSWORD_HASH
  • PATTERN
  • PERCENT
  • PERMISSIONS
  • PIVOT
  • PREVIOUS
  • PROPERTIES
  • PROPERTY
  • PUBLIC
  • QUARTER
  • QUERY
  • READ
  • READWRITE
  • RECURSIVE
  • RENAME
  • RETURN
  • RIGHT
  • ROWS
  • ROUTINE
  • SCHEMA
  • SECOND
  • SELECT
  • SEMANTICS
  • SEMANTIC_EQUIVALENT
  • SEMANTIC_GENERALIZATION
  • SEMANTIC_SPECIALIZATION
  • SERVER
  • SET
  • SHARE_DIMENSIONS
  • SIDE_EFFECTS
  • SINGLE
  • SKIP
  • SOLVE_ORDER
  • SOURCE
  • STATISTICS
  • STYLE
  • SUB
  • SUBQUERIES
  • SUCCESS
  • SUM
  • SUPPRESS
  • SYNCHRONIZE
  • SYNONYM
  • TABLE
  • TAG
  • TAIL
  • THEN
  • THIS
  • THIS_LEVEL
  • THIS_MEMBER
  • TIME
  • TIME_BUCKET
  • TO
  • TOP
  • TRACE
  • TRANSFORM
  • TRANSLATE
  • TREAT AS
  • TRUE
  • TUPLE
  • UNARY_OPERATOR
  • UNION
  • UNIQUE
  • UNLOAD
  • UPDATE
  • UPSERT
  • USER
  • VALUE
  • VALUES
  • VARIABLE
  • VERB
  • VERTICAL
  • VIEW
  • VISUAL_TOTALS
  • WHEN
  • WHERE
  • WHILE
  • WITH
  • WRITE
  • YEAR

DAX Keywords

Keywords used in Data Analysis Expressions (DAX), primarily for creating calculations in Power BI, Analysis Services Tabular models, and Power Pivot.

  • ADDCOLUMNS
  • ADDRESS
  • ALL
  • ALLCROSSFILTERED
  • ALLSELECTED
  • ALLEXCEPT
  • AND
  • APPVALUE
  • ASCENDING
  • CALCULATE
  • CALENDAR
  • CALENDARAUTO
  • CASE
  • CATALOGNAME
  • CELLORDINAL
  • CHOOSE
  • CLOSESTDATE
  • COLLAPSE
  • COLUMN
  • COLUMNVALUE
  • COMBINECOLUMNS
  • COMMITBYROW
  • CONCATENATE
  • CONCATENATEX
  • CONTINUOUS
  • COUNT
  • COUNTA
  • COUNTAX
  • COUNTBLANK
  • COUNTROWS
  • COUNTX
  • CROSSFILTER
  • CROSSAPPLY
  • CURRENCY
  • CURRENTGROUP
  • CUSTOMERGROUP
  • DATALENGTH
  • DATE
  • DATEADD
  • DATEDIFF
  • DATEVALUE
  • DAY
  • DEBUG
  • DEFAULTERROR
  • DEFAULT_VALUE
  • DEGREES
  • DENSEST
  • DETACH
  • DIMENSION
  • DISTANCE
  • DIVIDE
  • EARLIER
  • EOMONTH
  • ERROR
  • EVENTDATE
  • EVENTDATETIME
  • EXACT
  • EXCEPT
  • EXCLUDE
  • EXPAND
  • EXPECTEDRULES
  • EXTERNALREMOTEDATA
  • FILTER
  • FILTERGROUP
  • FIRSTDATE
  • FIRSTNONBLANK
  • FIRSTNONBLANKVALUE
  • FIXED
  • FOLDERPATH
  • FORMULATEXT
  • FROM
  • FULLNAME
  • GENERATESERIES
  • GETAFTERYEAR
  • GETAFTERQUARTER
  • GETAFTERMONTH
  • GETAFTERWEEK
  • GETAFTERDAY
  • GETBEFOREYEAR
  • GETBEFOREQUARTER
  • GETBEFOREMONTH
  • GETBEFOREWEEK
  • GETBEFOREDAY
  • GETBETWEENYEAR
  • GETBETWEENQUARTER
  • GETBETWEENMONTH
  • GETBETWEENWEEK
  • GETBETWEENDAY
  • GETCURRENTYEAR
  • GETCURRENTQUARTER
  • GETCURRENTMONTH
  • GETCURRENTWEEK
  • GETCURRENTDAY
  • GROUPBY
  • GUID
  • HEADER
  • HOUR
  • IF
  • IFERROR
  • IMAGETYPE
  • IN
  • INDEX
  • INT
  • INTERSECT
  • INVERTOF
  • ISAFTER
  • ISBEFORE
  • ISBETWEEN
  • ISBLANK
  • ISCLOSED
  • ISFILTERED
  • ISINACCUMULATIONTIMEFRAME
  • ISLEAPYEAR
  • ISLOGICAL
  • ISNONTEXT
  • ISNUMBER
  • ISONEAFTER
  • ISONEBEFORE
  • ISSAMEDATE
  • ISSAMEFILTER
  • ISSAMETIME
  • ISSUPPORTED
  • ISTEXT
  • ITEM
  • KEY
  • KOREAN
  • LASTDATE
  • LASTNONBLANK
  • LASTNONBLANKVALUE
  • LANGUAGE
  • LATESTOUTSTANDING
  • LEFT
  • LEN
  • LEVEL
  • LINKEDSERVER
  • LIST
  • LOG
  • LOG10
  • LOOKUPVALUE
  • LOWERCASE
  • MAJORIZATION
  • MAX
  • MAXA
  • MAXX
  • MEANDATE
  • MEDIAN
  • MEDIANX
  • MID
  • MIN
  • MINA
  • MINUTE
  • MINX
  • MISSING
  • MONTH
  • MONTHNAME
  • MODEL
  • MOD
  • MONEY
  • MOSTRECENT
  • MULTIVALUE
  • NAME
  • NAVIGATE
  • NEXTDAY
  • NEXTMONTH
  • NEXTQUARTER
  • NEXTWEEK
  • NEXTYEAR
  • NONBLANK
  • NORMALIZE
  • NOW
  • NPER
  • NUMBER
  • NUMBERVALUE
  • NUMERIC
  • OBJECT
  • OBSERVE
  • ODD
  • OFFLINE
  • ONORAFTER
  • ONORBEFORE
  • ONFILTERED
  • ONSELECTED
  • OPEN
  • OR
  • ORDER
  • ORDINAL
  • OUTER
  • OVERLAP
  • OVERLAPSTARTDATE
  • OVERLAPENDDATE
  • OVERLAPDURATION
  • PARENT
  • PASSWORD
  • PATINDEX
  • PERCENTAGE
  • PERCENTILE.INC
  • PERCENTILE.EXC
  • PERCENTILEX.INC
  • PERCENTILEX.EXC
  • PERMISSIONS
  • PI
  • PIVOT
  • PLANNERTYPE
  • POLICYTYPE
  • POWER
  • PRECEDENCE
  • PREVIOUSDAY
  • PREVIOUSMONTH
  • PREVIOUSQUARTER
  • PREVIOUSWEEK
  • PREVIOUSYEAR
  • PRIORITIER
  • PROBABILITY
  • PRODUCT
  • PRODUCTX
  • PROPERTIES
  • PROPERTY
  • PROTECT
  • PUBLIC
  • QUARTER
  • QUARTERNAME
  • QUERY
  • RAND
  • RANDBETWEEN
  • RATE
  • READ
  • READWRITE
  • REALTIME
  • RECALCULATE
  • RECIPIENT
  • RECURSIVE
  • REFRESH
  • REGRESSION
  • RELATED
  • RELATEDTABLE
  • REMAINDER
  • RENAME
  • REPLACE
  • REQUESTED
  • RETURN
  • RIGHT
  • ROLLBACK
  • ROLLUP
  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • ROWNUMBER
  • ROWS
  • ROWVALUE
  • ROUTINE
  • SAMPLE
  • SAMEPERIODLASTYEAR
  • SATISFIES
  • SAVE
  • SCHEMA
  • SCIPHER
  • SCORE
  • SECOND
  • SECURITY
  • SELECT
  • SEMANTICS
  • SEMANTIC_EQUIVALENT
  • SEMANTIC_GENERALIZATION
  • SEMANTIC_SPECIALIZATION
  • SEQUENTIAL
  • SERVER
  • SERVICE
  • SET
  • SETALL
  • SETFILTER
  • SETFOCUS
  • SETFOCUSGROUP
  • SETFOCUSROW
  • SETFOCUSCOLUMN
  • SETFOCUSMEASURE
  • SETFOCUSPAGE
  • SETFOCUSVISUAL
  • SETFOCUSCELL
  • SETFOCUSSEGMENT
  • SETFOCUSDATAPOINT
  • SETFOCUSLEGEND
  • SETFOCUSAXIS
  • SETFOCUSLEGENDITEM
  • SETFOCUSTOOLTIP
  • SETFOCUSDATALABEL
  • SETFOCUSDATAPOINTTOOLTIP
  • SETFOCUSLEGENDITEMTOOLTIP
  • SETFOCUSAXISTOOLTIP
  • SETFOCUSDATALABELTOOLTIP
  • SETFOCUSSEGMENTTOOLTIP
  • SHARE_DIMENSIONS
  • SHEETNAME
  • SHIFT
  • SHOWALL
  • SIGN
  • SIN
  • SINGLE
  • SINH
  • SKIP
  • SLICER
  • SLICERVALUE
  • SLICERITEM
  • SLICERHEADER
  • SLICERITEMHEADER
  • SLICERITEMVALUE
  • SLICERITEMTOOLTIP
  • SLICERHEADERTOOLTIP
  • SLICERITEMHEADERTOOLTIP
  • SLICERITEMVALUEtooltip
  • SLICERDATAPOINT
  • SLICERDATAPOINTTOOLTIP
  • SLICERLEGEND
  • SLICERLEGENDITEM
  • SLICERLEGENDITEMTOOLTIP
  • SLICERAXIS
  • SLICERAXISTOOLTIP
  • SLICERDATALABEL
  • SLICERDATALABELTOOLTIP
  • SLICERSEGMENT
  • SLICERSEGMENTTOOLTIP
  • SOLVE_ORDER
  • SOURCE
  • SQRT
  • STARTFROM
  • STATISTICS
  • STDEVP
  • STDEVPT
  • STDEV.P
  • STDEV.S
  • STDEV
  • STEPHISTORY
  • STOCKINFO
  • STORE
  • STORYBOARD
  • STORYBOARDFRAME
  • STORYBOARD FRAME RATE
  • STORYBOARD EFFECT
  • STORYBOARD EFFECT PARAMETER
  • STORYBOARDTRANSITION
  • STORYBOARDTRANSITION DURATION
  • STORYBOARD TRANSITION TYPE
  • STORYBOARDAUDIO
  • STORYBOARD AUDIO VOLUME
  • STORYBOARD AUDIO LOOP
  • STORYBOARD IMAGES
  • STORYBOARD IMAGE DURATION
  • STORYBOARD IMAGE TRANSITION
  • STORYBOARD TEXT
  • STORYBOARD TEXT DURATION
  • STORYBOARD TEXT TRANSITION
  • STORYBOARD VIDEO
  • STORYBOARD VIDEO DURATION
  • STORYBOARD VIDEO TRANSITION
  • STORYBOARD SCENE
  • STORYBOARD SCENE DURATION
  • STORYBOARD SCENE TRANSITION
  • STORYBOARD SUBTITLE
  • STORYBOARD SUBTITLE DURATION
  • STORYBOARD SUBTITLE TRANSITION
  • STORYBOARD EVENT
  • STORYBOARD EVENT DURATION
  • STORYBOARD EVENT TRANSITION
  • STYLE
  • SUB
  • SUBQUERIES
  • SUCCESS
  • SUM
  • SUMA
  • SUMX
  • SUMMARIZE
  • SUMMARIZECOLUMNS
  • SUPPRESS
  • SYNCHRONIZE
  • SYNONYM
  • TABLE
  • TABLENAME
  • TAG
  • TAIL
  • TARGET
  • TAXTYPE
  • TCALENDAR
  • TCALENDARS
  • TDATE
  • TDATEVALUE
  • TDAY
  • TDAYNAME
  • TDAYOFWEEK
  • TDAYOFYEAR
  • TEMPORALJOIN
  • TENURE
  • TEXT
  • TEXTAFTER
  • TEXTBEFORE
  • TEXTBETWEEN
  • TEXTLOWER
  • TEXTPROPER
  • TEXTSPLIT
  • TEXTUPPER
  • THEN
  • THIS
  • THIS_LEVEL
  • THIS_MEMBER
  • TIME
  • TIME_BUCKET
  • TIMEDIMENSION
  • TIMEKEY
  • TIMENOW
  • TIMESERIES
  • TO
  • TOP
  • TOTAL
  • TRACE
  • TRACKER
  • TRACKINGITEM
  • TRANSFORM
  • TRANSLATE
  • TREAT AS
  • TREATEDAS
  • TREATMENT
  • TREATED
  • TREATEDVALUE
  • TREATEDVALUEAGGREGATE
  • TREATEDVALUEITEM
  • TREATEDVALUEITEMAGGREGATE
  • TREATEDVALUEITEMLIST
  • TREATEDVALUEITEMLISTAGGREGATE
  • TREATEDVALUEITEMLISTITEM
  • TREATEDVALUEITEMLISTITEMAGGREGATE
  • TREATEDVALUEITEMLISTITEMLIST
  • TREATEDVALUEITEMLISTITEMLISTAGGREGATE
  • TREATEDVALUEITEMLISTITEMLISTITEM
  • TREATEDVALUEITEMLISTITEMLISTITEMAGGREGATE
  • TRUE
  • TUPLE
  • TXN
  • TYPE
  • UNARY_OPERATOR
  • UNDERLYINGVALUE
  • UNDEFINE
  • UNION
  • UNIQUE
  • UNLOAD
  • UNPIVOT
  • UNSORTED
  • UPDATE
  • UPPERCASE
  • UPSERT
  • USER
  • USERNAME
  • USERNAMEID
  • USERPRIORITIES
  • USERROLES
  • USERSETTINGS
  • USERTYPE
  • VALUE
  • VALUES
  • VAR
  • VARA
  • VARIABLE
  • VARX
  • VERB
  • VERTICAL
  • VERTICALAGGREGATION
  • VERTICALITEM
  • VERTICALITEMAGGREGATION
  • VERTICALITEMLIST
  • VERTICALITEMLISTAGGREGATE
  • VERTICALITEMLISTITEM
  • VERTICALITEMLISTITEMAGGREGATE
  • VERTICALITEMLISTITEMLIST
  • VERTICALITEMLISTITEMLISTAGGREGATE
  • VERTICALITEMLISTITEMLISTITEM
  • VERTICALITEMLISTITEMLISTITEMAGGREGATE
  • VIEW
  • VISUAL
  • VISUALTYPE
  • VISUALHEADER
  • VISUALHEADERTOOLTIP
  • VISUALITEM
  • VISUALITEMTOOLTIP
  • VISUALITEMHEADER
  • VISUALITEMHEADERTOOLTIP
  • VISUALITEMVALUE
  • VISUALITEMVALUETOOLTIP
  • VISUALLEGEND
  • VISUALLEGENDITEM
  • VISUALLEGENDITEMTOOLTIP
  • VISUALAXIS
  • VISUALAXISTOOLTIP
  • VISUALDATALABEL
  • VISUALDATALABELTOOLTIP
  • VISUALSEGMENT
  • VISUALSEGMENTTOOLTIP
  • VISUALDATAPOINT
  • VISUALDATAPOINTTOOLTIP
  • VISUALDATAPOINTHEADER
  • VISUALDATAPOINTHEADERTOOLTIP
  • VISUALDATAPOINTITEM
  • VISUALDATAPOINTITEMTOOLTIP
  • VISUALDATAPOINTITEMHEADER
  • VISUALDATAPOINTITEMHEADERTOOLTIP
  • VISUALDATAPOINTITEMVALUE
  • VISUALDATAPOINTITEMVALUETOOLTIP
  • VISUALIZATION
  • VISUALIZATIONTYPE
  • VISUALIZATIONHEADER
  • VISUALIZATIONHEADERTOOLTIP
  • VISUALIZATIONITEM
  • VISUALIZATIONITEMTOOLTIP
  • VISUALIZATIONITEMHEADER
  • VISUALIZATIONITEMHEADERTOOLTIP
  • VISUALIZATIONITEMVALUE
  • VISUALIZATIONITEMVALUETOOLTIP
  • VISUALIZATIONLEGEND
  • VISUALIZATIONLEGENDITEM
  • VISUALIZATIONLEGENDITEMTOOLTIP
  • VISUALIZATIONAXIS
  • VISUALIZATIONAXISTOOLTIP
  • VISUALIZATIONDATALABEL
  • VISUALIZATIONDATALABELTOOLTIP
  • VISUALIZATIONSEGMENT
  • VISUALIZATIONSEGMENTTOOLTIP
  • VISUALIZATIONDATAPOINT
  • VISUALIZATIONDATAPOINTTOOLTIP
  • VISUALIZATIONDATAPOINTHEADER
  • VISUALIZATIONDATAPOINTHEADERTOOLTIP
  • VISUALIZATIONDATAPOINTITEM
  • VISUALIZATIONDATAPOINTITEMTOOLTIP
  • VISUALIZATIONDATAPOINTITEMHEADER
  • VISUALIZATIONDATAPOINTITEMHEADERTOOLTIP
  • VISUALIZATIONDATAPOINTITEMVALUE
  • VISUALIZATIONDATAPOINTITEMVALUETOOLTIP
  • VOLUME
  • VOTES
  • WAITFOR
  • WALDEN
  • WALLCLOCK
  • WALLCLOCKVALUE
  • WALLCLOCKVALUEAGGREGATE
  • WALLCLOCKVALUEITEM
  • WALLCLOCKVALUEITEMAGGREGATE
  • WALLCLOCKVALUEITEMLIST
  • WALLCLOCKVALUEITEMLISTAGGREGATE
  • WALLCLOCKVALUEITEMLISTITEM
  • WALLCLOCKVALUEITEMLISTITEMAGGREGATE
  • WALLCLOCKVALUEITEMLISTITEMLIST
  • WALLCLOCKVALUEITEMLISTITEMLISTAGGREGATE
  • WALLCLOCKVALUEITEMLISTITEMLISTITEM
  • WALLCLOCKVALUEITEMLISTITEMLISTITEMAGGREGATE
  • WHEN
  • WHERE
  • WHILE
  • WIDTH
  • WINDOW
  • WINDOWFUNCTION
  • WINDOWFUNCTIONTYPE
  • WINDOWFUNCTIONHEADER
  • WINDOWFUNCTIONHEADERTOOLTIP
  • WINDOWFUNCTIONITEM
  • WINDOWFUNCTIONITEMTOOLTIP
  • WINDOWFUNCTIONITEMHEADER
  • WINDOWFUNCTIONITEMHEADERTOOLTIP
  • WINDOWFUNCTIONITEMVALUE
  • WINDOWFUNCTIONITEMVALUETOOLTIP
  • WINDOWFUNCTIONLEGEND
  • WINDOWFUNCTIONLEGENDITEM
  • WINDOWFUNCTIONLEGENDITEMTOOLTIP
  • WINDOWFUNCTIONAXIS
  • WINDOWFUNCTIONAXISTOOLTIP
  • WINDOWFUNCTIONDATALABEL
  • WINDOWFUNCTIONDATALABELTOOLTIP
  • WINDOWFUNCTIONSEGMENT
  • WINDOWFUNCTIONSEGMENTTOOLTIP
  • WINDOWFUNCTIONDATAPOINT
  • WINDOWFUNCTIONDATAPOINTTOOLTIP
  • WINDOWFUNCTIONDATAPOINTHEADER
  • WINDOWFUNCTIONDATAPOINTHEADERTOOLTIP
  • WINDOWFUNCTIONDATAPOINTITEM
  • WINDOWFUNCTIONDATAPOINTITEMTOOLTIP
  • WINDOWFUNCTIONDATAPOINTITEMHEADER
  • WINDOWFUNCTIONDATAPOINTITEMHEADERTOOLTIP
  • WINDOWFUNCTIONDATAPOINTITEMVALUE
  • WINDOWFUNCTIONDATAPOINTITEMVALUETOOLTIP
  • WITH
  • WORKBOOKOPEN
  • WORKBOOKCLOSE
  • WORKBOOKSAVE
  • WRITE
  • WRITEPARAM
  • WRITEPARAMVALUE
  • WRITEPARAMVALUEAGGREGATE
  • WRITEPARAMVALUEITEM
  • WRITEPARAMVALUEITEMAGGREGATE
  • WRITEPARAMVALUEITEMLIST
  • WRITEPARAMVALUEITEMLISTAGGREGATE
  • WRITEPARAMVALUEITEMLISTITEM
  • WRITEPARAMVALUEITEMLISTITEMAGGREGATE
  • WRITEPARAMVALUEITEMLISTITEMLIST
  • WRITEPARAMVALUEITEMLISTITEMLISTAGGREGATE
  • WRITEPARAMVALUEITEMLISTITEMLISTITEM
  • WRITEPARAMVALUEITEMLISTITEMLISTITEMAGGREGATE
  • XDATE
  • XDATEVALUE
  • XDAY
  • XDAYNAME
  • XDAYOFWEEK
  • XDAYOFYEAR
  • YEAR
  • YEARNAME
  • YEARNUMBER
  • ZDATE
  • ZDATEVALUE
  • ZDAY
  • ZDAYNAME
  • ZDAYOFWEEK
  • ZDAYOFYEAR