Glossary

Definitions for the terms used across our content on Power BI, Microsoft Fabric, Analysis Services, and DAX.

@

A

ABS

Returns the absolute value of a number. 
ABS ( Number )

ACCRINT

Returns the accrued interest for a security that pays periodic interest. 
ACCRINT ( Issue, First_interest, Settlement, Rate, Par, Frequency, [Basis], [Calc_method] )

ACCRINTM

Returns the accrued interest for a security that pays interest at maturity. 
ACCRINTM ( Issue, Maturity, Rate, Par, [Basis] )

ACOS

Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi. 
ACOS ( Number )

ACOSH

Returns the inverse hyperbolic cosine of a number. The number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine is number, so ACOSH(COSH(number)) equals number. 
ACOSH ( Number )

ACOT

Returns the principal value of the arccotangent, or inverse cotangent, of a number. 
ACOT ( Number )

ACOTH

Returns the inverse hyperbolic cotangent of a number. 
ACOTH ( Number )

ADDCOLUMNS

Returns a table with new columns specified by the DAX expressions. 
ADDCOLUMNS ( Table, Name, Expression, ... )

Addition (+)

DAX operator used to combine, compare, or transform values.

ADDMISSINGITEMS

Add the rows with empty measure values back. 
ADDMISSINGITEMS ( [ShowAll_ColumnName], ..., Table, [GroupBy_ColumnName], [FilterTable], ... )

ADLS

Azure Data Lake Storage; cloud storage capabilities for analytics workloads.

Aggregations

Pre-summarized tables that answer queries at a higher grain.

AI agent

AI agent; system that uses tools and iterates toward tasks.

AI Assistant

Tabular Editor assistant for guided model changes and scripts.

ALL

Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. 
ALL ( [TableNameOrColumnName], [ColumnName], ... )

ALLCROSSFILTERED

Clear all filters which are applied to the specified table. 
ALLCROSSFILTERED ( TableName )

ALLEXCEPT

Returns all the rows in a table except for those rows that are affected by the specified column filters. 
ALLEXCEPT ( TableName, ColumnName, ... )

ALLNOBLANKROW

Returns all the rows except blank row in a table, or all the values in a column, ignoring any filters that might have been applied. 
ALLNOBLANKROW ( TableNameOrColumnName, [ColumnName], ... )

ALLSELECTED

Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied inside the query, but keeping filters that come from outside. 
ALLSELECTED ( [TableNameOrColumnName], [ColumnName], ... )

ALLSELECTEDAPPLY

Modifies how filters are applied while evaluating a GROUPCROSSAPPLY or GROUPCROSSAPPLYTABLE function. 
ALLSELECTEDAPPLY ( TableExpression )

ALLSELECTEDREMOVE

Modifies how filters are applied while evaluating a GROUPCROSSAPPLY or GROUPCROSSAPPLYTABLE function. 
ALLSELECTEDREMOVE ( TableExpression, [Column], ... )

AlternateOf

The Alternate Of configuration used to specify aggregations.

AlternateSourcePrecedence

The ranking or precedence used to select the alternate source table in case more than one match is found.

ALWAYSAPPLY

Modifies how filters are applied while evaluating a GROUPCROSSAPPLY or GROUPCROSSAPPLYTABLE function. 
ALWAYSAPPLY ( TableExpression )

AMO

Analysis Management Objects; library for automating Analysis Services tabular models.

AMORDEGRC

Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. The function is similar to AMORLINC, except that a depreciation coefficient is applied in the calculation depending on the life of the assets. 
AMORDEGRC ( Cost, Date_purchased, First_period, Salvage, Period, Rate, [Basis] )

AMORLINC

Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. 
AMORLINC ( Cost, Date_purchased, First_period, Salvage, Period, Rate, [Basis] )

AND

Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE. 
AND ( Logical1, Logical2 )

And (&&)

DAX operator used to combine, compare, or transform values.

APPROXIMATEDISTINCTCOUNT

Returns an estimated count of the unique values in a column. This function invokes a corresponding aggregation operation in the data source, optimized for query performance but with slightly reduced accuracy. You can use APPROXIMATEDISTINCTCOUNT with the following data sources: Azure SQL, Azure SQL Data Warehouse, BigQuery, Databricks, and Snowflake. Note that this function requires DirectQuery mode. Import mode and dual storage mode are not supported. 
APPROXIMATEDISTINCTCOUNT ( ColumnName )

ASIN

Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number. The returned angle is given in radians in the range -pi/2 to pi/2. 
ASIN ( Number )

ASINH

Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value whose hyperbolic sine is number, so ASINH(SINH(number)) equals number. 
ASINH ( Number )

ATAN

Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2. 
ATAN ( Number )

ATANH

Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (excluding -1 and 1). The inverse hyperbolic tangent is the value whose hyperbolic tangent is number, so ATANH(TANH(number)) equals number. 
ATANH ( Number )

AuthenticationKind

Authentication kind, usually one of the AuthenticationKind constants.

auto-exist

DAX optimization that merges filters on columns from the same table.

AVERAGE

Returns the average (arithmetic mean) of all the numbers in a column. 
AVERAGE ( ColumnName )

AVERAGEA

Returns the average (arithmetic mean) of the values in a column. Handles text and non-numeric values. 
AVERAGEA ( ColumnName )

AVERAGEX

Calculates the average (arithmetic mean) of a set of expressions evaluated over a table. 
AVERAGEX ( Table, Expression )

AXIS COLUMNS

DAX statement keyword used to shape queries and calculations.

AXIS ROWS

DAX statement keyword used to shape queries and calculations.

Azure DevOps

Azure Development and Operations; Microsoft service for repositories, boards, and pipelines.

B

BaseColumn

A reference ID to the referenced source column.

BaseTable

A reference ID to the referenced source table.

BETA.DIST

Returns the beta distribution. The beta distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television. 
BETA.DIST ( X, Alpha, Beta, Cumulative, [A], [B] )

BETA.INV

Returns the inverse of the beta cumulative probability density function (BETA.DIST). If probability = BETA.DIST(x,...TRUE), then BETA.INV(probability,...) = x. The beta distribution can be used in project planning to model probable completion times given an expected completion time and variability. 
BETA.INV ( Probability, Alpha, Beta, [A], [B] )

bi-directional

Relationships that propagate filters in both directions.

Binary XML

Binary encoding that reduces XMLA protocol payload size.

BITAND

Returns a bitwise 'AND' of two numbers. 
BITAND ( Number1, Number2 )

BITLSHIFT

Returns a number shifted left by the specified number of bits. 
BITLSHIFT ( Number, ShiftAmount )

BITOR

Returns a bitwise 'OR' of two numbers. 
BITOR ( Number1, Number2 )

BITRSHIFT

Returns a number shifted right by the specified number of bits. 
BITRSHIFT ( Number, ShiftAmount )

BITXOR

Returns a bitwise 'XOR' of two numbers. 
BITXOR ( Number1, Number2 )

BLANK

Returns a blank. 
BLANK ( )

Boolean

DAX data type used by expressions and model metadata.

BPA

Best Practice Analyzer; rule-based checker for model quality and consistency.

C

C# script

Reusable Tabular Editor automation script for model metadata changes.

C# scripting

Tabular Editor automation using C# to modify model metadata.

CALCULATE

Evaluates an expression in a context modified by filters. 
CALCULATE ( Expression, [Filter], ... )

CALCULATETABLE

Evaluates a table expression in a context modified by filters. 
CALCULATETABLE ( Table, [Filter], ... )

calculation group

Model object that applies reusable calculation logic to measures.

CalculationGroupPrecedence

When multiple Calculation Groups are used as a filter condition, this property determines the order of evaluation.

CALENDAR

Returns a table with one column of all dates between StartDate and EndDate. 
CALENDAR ( StartDate, EndDate )

Calendar Editor

Tabular Editor tool for creating calendars for enhanced time intelligence.

CALENDARAUTO

Returns a table with one column of dates calculated from the model automatically. 
CALENDARAUTO ( [FiscalYearEndMonth] )

CEILING

Rounds a number up, to the nearest integer or to the nearest unit of significance. 
CEILING ( Number, Significance )

CHISQ.DIST

Returns the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television. 
CHISQ.DIST ( X, Deg_freedom, Cumulative )

CHISQ.DIST.RT

Returns the right-tailed probability of the chi-squared distribution. The chi-squared distribution is associated with a chi-squared test. Use the chi-squared test to compare observed and expected values. For example, a genetic experiment might hypothesize that the next generation of plants will exhibit a certain set of colors. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid. 
CHISQ.DIST.RT ( X, Deg_freedom )

CHISQ.INV

Returns the inverse of the left-tailed probability of the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television. 
CHISQ.INV ( Probability, Deg_freedom )

CHISQ.INV.RT

Returns the inverse of the right-tailed probability of the chi-squared distribution. If probability = CHISQ.DIST.RT(x,...), then CHISQ.INV.RT(probability,...) = x. Use this function to compare observed results with expected ones in order to decide whether your original hypothesis is valid. 
CHISQ.INV.RT ( Probability, Deg_freedom )

CI/CD

Continuous Integration / Continuous Delivery; practices for validating and releasing changes through automation.

Claude Code

Anthropic coding agent that works from the command line.

CLOSINGBALANCEMONTH

Evaluates the specified expression for the date corresponding to the end of the current month after applying specified filters. 
CLOSINGBALANCEMONTH ( Expression, Dates, [Filter] )

CLOSINGBALANCEQUARTER

Evaluates the specified expression for the date corresponding to the end of the current quarter after applying specified filters. 
CLOSINGBALANCEQUARTER ( Expression, Dates, [Filter] )

CLOSINGBALANCEWEEK

Evaluates the specified expression for the date corresponding to the end of the current week after applying specified filters. 
CLOSINGBALANCEWEEK ( Expression, Calendar, [Filter] )

CLOSINGBALANCEYEAR

Evaluates the specified expression for the date corresponding to the end of the current year after applying specified filters. 
CLOSINGBALANCEYEAR ( Expression, Dates, [Filter], [YearEndDate] )

COALESCE

Returns the first argument that doesn't evaluate to a blank value. If all arguments evaluate to blank values, BLANK is returned. 
COALESCE ( Value1, Value2, ... )

Code Actions

Editor quick fixes for refactoring DAX and model code.

Code Assist

DAX Editor suggestions, parameter help, and context-aware completion.

coding agent

AI agent that reads and modifies project files or code.

COLLAPSE

Retrieves a context with removed detail levels compared to the current context. With an expression, returns its value in the new context, allowing navigation up hierarchies and calculation at a coarser level of detail. 
COLLAPSE ( [Expression], [Axis], [Column], ..., [N] )

COLLAPSEALL

Retrieves a context with removed detail levels along an axis. With an expression, returns its value in the new context, enabling navigation to the highest level on the axis and is the inverse of EXPANDALL. 
COLLAPSEALL ( [Expression], Axis )

COLUMN

DAX statement keyword used to shape queries and calculations.

COLUMNSTATISTICS

Provides statistics regarding every column in every table in the model. 
COLUMNSTATISTICS ( )

COMBIN

Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items. 
COMBIN ( Number, Number_chosen )

COMBINA

Returns the number of combinations (with repetitions) for a given number of items. 
COMBINA ( Number, Number_chosen )

COMBINEVALUES

Combines the given set of operands using a specified delimiter. 
COMBINEVALUES ( Delimiter, Expression1, Expression2, ... )

composite model

Power BI model combining multiple storage modes or remote models.

CONCATENATE

Joins two text strings into one text string. 
CONCATENATE ( Text1, Text2 )

CONCATENATEX

Evaluates expression for each row on the table, then return the concatenation of those values in a single string result, separated by the specified delimiter. 
CONCATENATEX ( Table, Expression, [Delimiter], [OrderBy_Expression], [Order], ... )

CONFIDENCE.NORM

Returns the confidence interval for a population mean, using a normal distribution. 
CONFIDENCE.NORM ( Alpha, Standard_dev, Size )

CONFIDENCE.T

Returns the confidence interval for a population mean, using a Student's t distribution. 
CONFIDENCE.T ( Alpha, Standard_dev, Size )

CONTAINS

Returns TRUE if there exists at least one row where all columns have specified values. 
CONTAINS ( Table, ColumnName, Value, ... )

CONTAINSROW

Returns TRUE if there exists at least one row where all columns have specified values. 
CONTAINSROW ( Table, Value, ... )

CONTAINSSTRING

Returns TRUE if one text string contains another text string. CONTAINSSTRING isn't case-sensitive, but it is accent-sensitive. 
CONTAINSSTRING ( WithinText, FindText )

CONTAINSSTRINGEXACT

Returns TRUE if one text string contains another text string. CONTAINSSTRINGEXACT is case-sensitive and accent-sensitive. 
CONTAINSSTRINGEXACT ( WithinText, FindText )

ContentType

Specifies the type of the linguistic metadata from the Content property.

Conversational BI

Conversational Business Intelligence; analytics through natural-language data questions.

CONVERT

Convert an expression to the specified data type. 
CONVERT ( Expression, DataType )

COS

Returns the cosine of the given angle. 
COS ( Number )

COSH

Returns the hyperbolic cosine of a number. 
COSH ( Number )

COT

Return the cotangent of an angle specified in radians. 
COT ( Number )

COTH

Return the hyperbolic cotangent of a hyperbolic angle. 
COTH ( Number )

COUNT

Counts the number of rows in the table where the specified column has a non-blank value. 
COUNT ( ColumnName )

COUNTA

Counts the number of values in a column. 
COUNTA ( ColumnName )

COUNTAX

Counts the number of values which result from evaluating an expression for each row of a table. 
COUNTAX ( Table, Expression )

COUNTBLANK

Counts the number of blanks in a column. 
COUNTBLANK ( ColumnName )

COUNTROWS

Counts the number of rows in a table. 
COUNTROWS ( [Table] )

COUNTX

Counts the number of values which result from evaluating an expression for each row of a table. 
COUNTX ( Table, Expression )

COUPDAYBS

Returns the number of days from the beginning of a coupon period until its settlement date. 
COUPDAYBS ( Settlement, Maturity, Frequency, [Basis] )

COUPDAYS

Returns the number of days in the coupon period that contains the settlement date. 
COUPDAYS ( Settlement, Maturity, Frequency, [Basis] )

COUPDAYSNC

Returns the number of days from the settlement date to the next coupon date. 
COUPDAYSNC ( Settlement, Maturity, Frequency, [Basis] )

COUPNCD

Returns the next coupon date after the settlement date. 
COUPNCD ( Settlement, Maturity, Frequency, [Basis] )

COUPNUM

Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon. 
COUPNUM ( Settlement, Maturity, Frequency, [Basis] )

COUPPCD

Returns the previous coupon date before the settlement date. 
COUPPCD ( Settlement, Maturity, Frequency, [Basis] )

cross-filtering

Report interaction where one visual filters another visual.

CROSSFILTER

Specifies cross filtering direction to be used in the evaluation of a DAX expression. The relationship is defined by naming, as arguments, the two columns that serve as endpoints. 
CROSSFILTER ( LeftColumnName, RightColumnName, CrossFilterType )

CROSSJOIN

Returns a table that is a crossjoin of the specified tables. 
CROSSJOIN ( Table, ... )

CUMIPMT

Returns the cumulative interest paid on a loan between start_period and end_period. 
CUMIPMT ( Rate, Nper, Pv, Start_period, End_period, Type )

CUMPRINC

Returns the cumulative principal paid on a loan between start_period and end_period. 
CUMPRINC ( Rate, Nper, Pv, Start_period, End_period, Type )

CURRENCY

Returns the value as a currency data type. 
CURRENCY ( Value )

Currency

DAX data type used by expressions and model metadata.

CURRENTGROUP

Access to the (sub)table representing current group in GroupBy function. Can be used only inside GroupBy function. 
CURRENTGROUP ( )

CUSTOMDATA

Returns the value of the CustomData connection string property if defined; otherwise, BLANK(). 
CUSTOMDATA ( )

D

D3.js

Data-Driven Documents; JavaScript library for data-driven browser visualizations.

Data app

Fabric app template for analytical experiences over semantic models.

Data Factory

Fabric workload for ingesting, transforming, and orchestrating data.

Data Visualization

Presenting data visually so people can understand patterns and exceptions.

Database.json

Serialized semantic model metadata used by development tools.

Databricks SQL

SQL warehousing experience for queries and dashboards.

DataCategory

Specifies the type of data contained in the column so that you can add custom behaviors based on column type.

DataCoverageDefinition

A reference to an optional DataCoverageDefinition that provides the hint regarding the data that is covered by the partition.

Dataflow Gen1

Power BI dataflow generation for reusable Power Query transformations.

Dataflow Gen2

Dataflow Generation 2; Fabric dataflow for cloud data preparation.

Dataflows

Power Query-based Fabric item for reusable data preparation.

DataOps

Practices for improving data delivery through collaboration and automation.

DataSourceDefaultMaxConnections

DataSourceDefaultMaxConnections will be used for connections to a data source if MaxConnections is set to -1 on the data source object or if there is no corresponding data source object for the data source.

DATATABLE

Returns a table with data defined inline. 
DATATABLE ( Name, DataType, ..., Data )

DataType

TOM property specifying the value type of a column or measure.

DataView

Determines which partitions should be selected to run queries against the model.

DATE

Returns the specified date in datetime format. 
DATE ( Year, Month, Day )

DATEADD

Moves the given set of dates by a specified interval. 
DATEADD ( Dates, NumberOfIntervals, Interval, [Extension], [Truncation] )

DATEDIFF

Returns the number of units (unit specified in Interval) between the input two dates. 
DATEDIFF ( Date1, Date2, Interval )

DATESBETWEEN

Returns the dates between two given dates. 
DATESBETWEEN ( Dates, StartDate, EndDate )

DATESINPERIOD

Returns the dates from the given period. 
DATESINPERIOD ( Dates, StartDate, NumberOfIntervals, Interval, [EndBehavior] )

DATESMTD

Returns a set of dates in the month up to the last date visible in the filter context. 
DATESMTD ( Dates )

DATESQTD

Returns a set of dates in the quarter up to the last date visible in the filter context. 
DATESQTD ( Dates )

DATESWTD

Returns a set of dates in the week up to current date. 
DATESWTD ( Calendar )

DATESYTD

Returns a set of dates in the year up to the last date visible in the filter context. 
DATESYTD ( Dates, [YearEndDate] )

DateTime

DAX data type used by expressions and model metadata.

DATEVALUE

Converts a date in the form of text to a date in datetime format. 
DATEVALUE ( DateText )

DAX Debugger

Tabular Editor feature for stepping through DAX evaluation.

DAX Editor

Tabular Editor editor for authoring and refactoring DAX expressions.

DAX Lib

DAX Library; open package library for reusable functions.

DAX Optimizer

Tool for finding and explaining DAX performance issues.

DAX query

Statement returning tables from a semantic model.

DAX Query view

Power BI Desktop window for writing and testing DAX queries.

DAX Query window

Tabular Editor window for running DAX queries against models.

DAX Script

Tabular Editor document for editing DAX objects together.

DAX scripting

Tabular Editor workflow for bulk-editing DAX expressions.

DAX Studio

External tool for writing, running, and analyzing DAX queries.

DAX UDF

DAX User-Defined Function; reusable calculation logic inside a semantic model.

DAY

Returns a number from 1 to 31 representing the day of the month. 
DAY ( Date )

DB

Returns the depreciation of an asset for a specified period using the fixed-declining balance method. 
DB ( Cost, Salvage, Life, Period, [Month] )

DDB

Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify. 
DDB ( Cost, Salvage, Life, Period, [Factor] )

Decimal

DAX data type used by expressions and model metadata.

DefaultDataView

Used by partitions in the model to determine the type of query that retrieves data.

DefaultMode

The default method for making data available in the partition.

DEFINE

DAX statement keyword used to shape queries and calculations.

Define Measure

DAX Editor command that inserts a referenced measure definition.

DEGREES

Converts radians into degrees. 
DEGREES ( Number )

Delta Lake

Open table format that adds reliability to data lakes.

Deneb

Power BI custom visual for Vega and Vega-Lite charts.

DENSIFY

DAX statement keyword used to shape queries and calculations.

DETAILROWS

Returns the table data corresponding to the DetailRows expression defined on the specified Measure. If a DetailRows expression isn't defined then the entire table to which the Measure belongs is returned. 
DETAILROWS ( Measure )

DetailRowsExpression

A DAX expression specifying detail rows for this measure (drill-through in client tools).

DirectLake

Storage mode that reads OneLake tables through the VertiPaq engine.

DirectQuery

Storage mode that sends queries back to the source system.

DISC

Returns the discount rate for a security. 
DISC ( Settlement, Maturity, Pr, Redemption, [Basis] )

DisplayFolder

Folder path used to organize objects in client tools.

DisplayOrdinal

Indicates the visual position of the column, defined as a relative ordering rather than a strict ordering (example: 10, 20, 40, 50).

DISTINCT

Returns a one column table that contains the distinct (unique) values in a column, for a column argument. Or multiple columns with distinct (unique) combination of values, for a table expression argument. 
DISTINCT ( ColumnNameOrTableExpr )

DISTINCTCOUNT

Counts the number of distinct values in a column. 
DISTINCTCOUNT ( ColumnName )

DISTINCTCOUNTNOBLANK

Counts the number of distinct values in a column. 
DISTINCTCOUNTNOBLANK ( ColumnName )

DIVIDE

Safe Divide function with ability to handle divide by zero case. 
DIVIDE ( Numerator, Denominator, [AlternateResult] )

Division (/)

DAX operator used to combine, compare, or transform values.

DOLLARDE

Converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number. Fractional dollar numbers are sometimes used for securities prices. 
DOLLARDE ( Fractional_dollar, Fraction )

DOLLARFR

Converts a dollar price expressed as a decimal number into a dollar price expressed as an integer part and a fraction part, such as 1.02. Fractional dollar numbers are sometimes used for securities prices. 
DOLLARFR ( Decimal_dollar, Fraction )

drilldown

Report interaction that moves into lower hierarchy levels.

drillthrough

Report navigation that opens detail pages for selected data.

DURATION

Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price's response to changes in yield. 
DURATION ( Settlement, Maturity, Coupon, Yld, Frequency, [Basis] )

E

EARLIER

Returns the value in the column prior to the specified number of table scans (default is 1). 
EARLIER ( ColumnName, [Number] )

EARLIEST

Returns the value in the column for the very first point at which there was a row context. 
EARLIEST ( ColumnName )

EDATE

Returns the date that is the indicated number of months before or after the start date. 
EDATE ( StartDate, Months )

EFFECT

Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year. 
EFFECT ( Nominal_rate, Npery )

ELT

Extract, Load, Transform; pattern that transforms data after loading it.

EncodingHint

This property allows an encoding hint to be specified for the column.

ENDOFMONTH

Returns the end of month. 
ENDOFMONTH ( Dates )

ENDOFQUARTER

Returns the end of quarter. 
ENDOFQUARTER ( Dates )

ENDOFWEEK

Returns the end of week. 
ENDOFWEEK ( Calendar )

ENDOFYEAR

Returns the end of year. 
ENDOFYEAR ( Dates, [YearEndDate] )

EntityName

The Name of the underlying referenced object used to query and populate current partition.

EOMONTH

Returns the date in datetime format of the last day of the month before or after a specified number of months. 
EOMONTH ( StartDate, Months )

Equal to (=)

DAX operator used to combine, compare, or transform values.

ERROR

Raises a user specified error. 
ERROR ( ErrorText )

ETL

Extract, Transform, Load; pattern that transforms data before loading it.

EVALUATE

DAX statement keyword used to shape queries and calculations.

EVALUATEANDLOG

Return the value of the first argument and also log the value in DAX evaluation log. 
EVALUATEANDLOG ( Value, [Label], [MaxRows] )

EVEN

Returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts rows of one or two items. The crate is full when the number of items, rounded up to the nearest two, matches the crate's capacity. 
EVEN ( Number )

Eventhouse

Fabric item for storing and querying high-volume event data.

EXACT

Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive. 
EXACT ( Text1, Text2 )

EXCEPT

Returns the rows of left-side table which do not appear in right-side table. 
EXCEPT ( LeftTable, RightTable )

EXP

Returns e raised to the power of a given number. 
EXP ( Number )

EXPAND

Retrieves a context with added levels of detail compared to the current context. If an expression is provided, returns its value in the new context, allowing for navigation in hierarchies and calculation at a more detailed level. 
EXPAND ( [Expression], [Axis], [Column], ..., [N] )

EXPANDALL

Retrieves a context with added detail levels along an axis compared to the current context. With an expression, returns its value in the new context, enabling navigation to the lowest level on the axis, and is the inverse of COLLAPSEALL. 
EXPANDALL ( [Expression], Axis )

EXPON.DIST

Returns the exponential distribution. Use EXPON.DIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPON.DIST to determine the probability that the process takes at most 1 minute. 
EXPON.DIST ( X, Lambda, Cumulative )

ExpressionSource

A reference to the NamedExpression where the parameter associated with the remote model.

EXTERNALMEASURE

Invoke a measure defined in a remote model. 
EXTERNALMEASURE ( MeasureName, [Type], [Datasource] )

F

Fabric App

Fabric item type for building and sharing web applications.

Fabric CLI

Fabric CLI for managing resources and automation.

Fabric Lakehouse

Fabric item combining data lake storage with database-style organization.

FACT

Returns the factorial of a number, equal to 1*2*3*...* Number. 
FACT ( Number )

FALSE

Returns the logical value FALSE. 
FALSE ( )

FastCombine

Whether privacy settings on individual data sources should be ignored.

field parameter

Power BI feature for switching fields or measures in visuals.

FILTER

Returns a table that has been filtered. 
FILTER ( Table, FilterExpression )

filter context

Active filters that shape how a DAX expression evaluates.

FILTERCLUSTER

Returns a correlated join table over a set of groups. 
FILTERCLUSTER ( GroupBy_ColumnName, FilterTable, ..., Separator, TableScan, ... )

FilterExpression

The DAX expression that filters the rows in the table when this security role is in effect.

FILTERS

Returns a table of the filter values applied directly to the specified column. 
FILTERS ( ColumnName )

FIND

Returns the starting position of one text string within another text string. FIND is case-sensitive and accent-sensitive. 
FIND ( FindText, WithinText, [StartPosition], [NotFoundValue] )

FIRST

The First function retrieves a value in the Visual Calculation data grid from the first row of an axis. 
FIRST ( Column, [Axis], [OrderBy], [Blanks], [Reset] )

FIRSTDATE

Returns first non blank date. 
FIRSTDATE ( Dates )

FIRSTNONBLANK

Returns the first value in the column for which the expression has a non blank value. 
FIRSTNONBLANK ( ColumnName, Expression )

FIRSTNONBLANKVALUE

Returns the first non blank value of the expression that evaluated for the column. 
FIRSTNONBLANKVALUE ( ColumnName, Expression )

FIXED

Rounds a number to the specified number of decimals and returns the result as text with optional commas. 
FIXED ( Number, [Decimals], [NoCommas] )

FLOOR

Rounds a number down, toward zero, to the nearest multiple of significance. 
FLOOR ( Number, Significance )

ForceUniqueNames

Determines whether measures can have the same names as any column in the model.

FORMAT

Converts a value to text in the specified number format. 
FORMAT ( Value, Format, [LocaleName] )

Format DAX

DAX Editor command for formatting expressions and query documents.

FormatString

Static format string used to display measure or column values.

FromCardinality

Indicates whether the "From" end of the relationship has a cardinality of One (1) or Many (2).

FromColumn

The starting column in a single column relationship.

FromTable

The starting table in a directional table relationship.

FUNCTION

DAX statement keyword used to shape queries and calculations.

FV

Calculates the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, or a single lump sum payment. 
FV ( Rate, Nper, Pmt, [Pv], [Type] )

G

GCD

Returns the greatest common divisor of two integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder. 
GCD ( Number1, Number2 )

GENERATE

The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table with these results. 
GENERATE ( Table1, Table2 )

GENERATEALL

The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table with these results, including rows for which the second table expression is empty. 
GENERATEALL ( Table1, Table2 )

GENERATESERIES

Returns a table with one column, populated with sequential values from start to end. 
GENERATESERIES ( StartValue, EndValue, [IncrementValue] )

GEOMEAN

Returns geometric mean of given column reference. 
GEOMEAN ( ColumnName )

GEOMEANX

Returns geometric mean of an expression values in a table. 
GEOMEANX ( Table, Expression )

GitHub Actions

GitHub automation platform for workflows, builds, and deployments.

Granularity

The granularity of the refresh policy for this partition

GROUP

DAX statement keyword used to shape queries and calculations.

GROUPBY

Creates a summary the input table grouped by the specified columns. 
GROUPBY ( Table, [GroupBy_ColumnName], [Name], [Expression], ... )

GROUPCROSSAPPLY

Returns a summary table over a set of groups. 
GROUPCROSSAPPLY ( GroupBy_ColumnName, FilterTable, Name, Expression, ... )

GROUPCROSSAPPLYTABLE

Returns a summary table over a set of groups. 
GROUPCROSSAPPLYTABLE ( GroupBy_ColumnName, FilterTable, Name, TableExpression, ... )

H

HASH

Compute hash over a variable number of input expressions and return a value. 
HASH ( Expression, ... )

HASONEFILTER

Returns true when the specified table or column has one and only one value resulting from direct filter(s). 
HASONEFILTER ( ColumnName )

HASONEVALUE

Returns true when there's only one value in the specified column. 
HASONEVALUE ( ColumnName )

HideMembers

Ragged/unbalanced hierarchies can be enabled by hiding members using this property.

HOUR

Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.). 
HOUR ( Datetime )

Hybrid tables

Power BI tables combining import partitions with real-time DirectQuery.

I

IdentityProvider

A string that defines the identity provider used for authentication.

IF

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. 
IF ( LogicalTest, ResultIfTrue, [ResultIfFalse] )

IF.EAGER

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. Uses eager execution plan. 
IF.EAGER ( LogicalTest, ResultIfTrue, [ResultIfFalse] )

IFERROR

Returns value_if_error if the first expression is an error and the value of the expression itself otherwise. 
IFERROR ( Value, ValueIfError )

IGNORE

Tags a measure expression specified in the call to SUMMARIZECOLUMNS function to be ignored when determining the non-blank rows. 
IGNORE ( Measure_Expression )

ImpersonationMode

Determines how credentials are obtained for an impersonated connection to a data source during data import or refresh.

Import mode

Storage mode that loads source data into the semantic model.

IN

DAX operator used to combine, compare, or transform values.

INDEX

Retrieves a row at an absolute position (specified by the position parameter) within the specified partition sorted by the specified order or on the axis specified. 
INDEX ( Position, [Relation], [OrderBy], [Blanks], [PartitionBy], [MatchBy], [Reset] )

INFO.ALTERNATEOFDEFINITIONS

Returns rows from the TMSCHEMA_ALTERNATE_OF_DEFINITIONS data management view. 
INFO.ALTERNATEOFDEFINITIONS ( [RestrictionName], [RestrictionValue], ... )

INFO.ANNOTATIONS

Returns a list of all annotations in the current model with columns matching the schema rowset for annotation objects. 
INFO.ANNOTATIONS ( [RestrictionName], [RestrictionValue], ... )

INFO.ATTRIBUTEHIERARCHIES

Represents the TMSCHEMA_ATTRIBUTE_HIERARCHIES DMV query function. 
INFO.ATTRIBUTEHIERARCHIES ( [RestrictionName], [RestrictionValue], ... )

INFO.ATTRIBUTEHIERARCHYSTORAGES

Returns rows from the TMSCHEMA_ATTRIBUTE_HIERARCHY_STORAGES data management view. 
INFO.ATTRIBUTEHIERARCHYSTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.CALCDEPENDENCY

Returns information about the calculation dependency for a DAX query. 
INFO.CALCDEPENDENCY ( [RestrictionName], [RestrictionValue], ... )

INFO.CALCULATIONGROUPS

Returns rows from the TMSCHEMA_CALCULATION_GROUPS data management view. 
INFO.CALCULATIONGROUPS ( [RestrictionName], [RestrictionValue], ... )

INFO.CALCULATIONITEMS

Returns rows from the TMSCHEMA_CALCULATION_ITEMS data management view. 
INFO.CALCULATIONITEMS ( [RestrictionName], [RestrictionValue], ... )

INFO.CALENDARCOLUMNGROUPS

Represents the TMSCHEMA_CALENDAR_COLUMN_GROUPS DMV query function. 
INFO.CALENDARCOLUMNGROUPS ( [RestrictionName], [RestrictionValue], ... )

INFO.CALENDARCOLUMNREFERENCES

Represents the TMSCHEMA_CALENDAR_COLUMN_REFERENCES DMV query function. 
INFO.CALENDARCOLUMNREFERENCES ( [RestrictionName], [RestrictionValue], ... )

INFO.CALENDARS

Represents the TMSCHEMA_CALENDARS DMV query function. 
INFO.CALENDARS ( [RestrictionName], [RestrictionValue], ... )

INFO.CATALOGS

Represents the DBSCHEMA_CATALOGS DMV query function. 
INFO.CATALOGS ( [RestrictionName], [RestrictionValue], ... )

INFO.CHANGEDPROPERTIES

Represents the TMSCHEMA_CHANGED_PROPERTIES DMV query function. 
INFO.CHANGEDPROPERTIES ( [RestrictionName], [RestrictionValue], ... )

INFO.COLUMNPARTITIONSTORAGES

Returns rows from the TMSCHEMA_COLUMN_PARTITION_STORAGES data management view. 
INFO.COLUMNPARTITIONSTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.COLUMNPERMISSIONS

Returns a list of all column permissions in the current model with columns matching the schema rowset for column permissions objects. 
INFO.COLUMNPERMISSIONS ( [RestrictionName], [RestrictionValue], ... )

INFO.COLUMNS

Returns a list of all columns in the current model with columns matching the schema rowset for column objects. 
INFO.COLUMNS ( [RestrictionName], [RestrictionValue], ... )

INFO.COLUMNSTORAGES

Returns a list of all column storages in the current model with columns matching the schema rowset for column storage objects. 
INFO.COLUMNSTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.CSDLMETADATA

Returns information about database metadata in XML format. 
INFO.CSDLMETADATA ( [RestrictionName], [RestrictionValue], ... )

INFO.CULTURES

Returns a list of all cultures in the current model with columns matching the schema rowset for culture objects. 
INFO.CULTURES ( [RestrictionName], [RestrictionValue], ... )

INFO.DATACOVERAGEDEFINITIONS

Returns rows from the TMSCHEMA_DATA_COVERAGE_DEFINITIONS data management view. 
INFO.DATACOVERAGEDEFINITIONS ( [RestrictionName], [RestrictionValue], ... )

INFO.DATASOURCES

Represents the TMSCHEMA_DATASOURCES DMV query function. 
INFO.DATASOURCES ( [RestrictionName], [RestrictionValue], ... )

INFO.DELTATABLEMETADATASTORAGES

Returns rows from the TMSCHEMA_DELTA_TABLE_METADATA_STORAGES data management view. 
INFO.DELTATABLEMETADATASTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.DEPENDENCIES

Returns information about the calculation dependency for a DAX query. 
INFO.DEPENDENCIES ( [RestrictionName], [RestrictionValue], ... )

INFO.DETAILROWSDEFINITIONS

Returns a list of all detail rows definitions in the current model with columns matching the schema rowset for detail rows definitions objects. 
INFO.DETAILROWSDEFINITIONS ( [RestrictionName], [RestrictionValue], ... )

INFO.DICTIONARYSTORAGES

Returns rows from the TMSCHEMA_DICTIONARY_STORAGES data management view. 
INFO.DICTIONARYSTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.EXCLUDEDARTIFACTS

Represents the TMSCHEMA_EXCLUDED_ARTIFACTS DMV query function. 
INFO.EXCLUDEDARTIFACTS ( [RestrictionName], [RestrictionValue], ... )

INFO.EXPRESSIONS

Returns a list of all expressions in the current model with columns matching the schema rowset for expressions objects. 
INFO.EXPRESSIONS ( [RestrictionName], [RestrictionValue], ... )

INFO.EXTENDEDPROPERTIES

Returns a list of all extended properties in the current model with columns matching the schema rowset for extended properties objects. 
INFO.EXTENDEDPROPERTIES ( [RestrictionName], [RestrictionValue], ... )

INFO.FORMATSTRINGDEFINITIONS

Returns rows from the TMSCHEMA_FORMAT_STRING_DEFINITIONS data management view. 
INFO.FORMATSTRINGDEFINITIONS ( [RestrictionName], [RestrictionValue], ... )

INFO.FUNCTIONS

Returns information about the functions that are currently available for use in the DAX programming language. 
INFO.FUNCTIONS ( [RestrictionName], [RestrictionValue], ... )

INFO.GENERALSEGMENTMAPSEGMENTMETADATASTORAGES

Returns rows from the TMSCHEMA_GENERAL_SEGMENT_MAP_SEGMENT_METADATA_STORAGES data management view. 
INFO.GENERALSEGMENTMAPSEGMENTMETADATASTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.GROUPBYCOLUMNS

Returns rows from the TMSCHEMA_GROUP_BY_COLUMNS data management view. 
INFO.GROUPBYCOLUMNS ( [RestrictionName], [RestrictionValue], ... )

INFO.HIERARCHIES

Represents the TMSCHEMA_HIERARCHIES DMV query function. 
INFO.HIERARCHIES ( [RestrictionName], [RestrictionValue], ... )

INFO.HIERARCHYSTORAGES

Returns rows from the TMSCHEMA_HIERARCHY_STORAGES data management view. 
INFO.HIERARCHYSTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.KPIS

Returns a list of all KPIS in the current model with columns matching the schema rowset for KPI objects. 
INFO.KPIS ( [RestrictionName], [RestrictionValue], ... )

INFO.LEVELS

Returns a list of all levels in the current model with columns matching the schema rowset for level objects. 
INFO.LEVELS ( [RestrictionName], [RestrictionValue], ... )

INFO.LINGUISTICMETADATA

Represents the TMSCHEMA_LINGUISTIC_METADATA DMV query function. 
INFO.LINGUISTICMETADATA ( [RestrictionName], [RestrictionValue], ... )

INFO.MEASURES

Returns a list of all measures in the current model with columns matching the schema rowset for measure objects. 
INFO.MEASURES ( [RestrictionName], [RestrictionValue], ... )

INFO.MODEL

Represents the TMSCHEMA_MODEL DMV query function. 
INFO.MODEL ( [RestrictionName], [RestrictionValue], ... )

INFO.OBJECTTRANSLATIONS

Returns a list of all object translations in the current model with columns matching the schema rowset for object translation objects. 
INFO.OBJECTTRANSLATIONS ( [RestrictionName], [RestrictionValue], ... )

INFO.PARQUETFILESTORAGES

Returns rows from the TMSCHEMA_PARQUET_FILE_STORAGES data management view. 
INFO.PARQUETFILESTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.PARTITIONS

Represents the TMSCHEMA_PARTITIONS DMV query function. 
INFO.PARTITIONS ( [RestrictionName], [RestrictionValue], ... )

INFO.PARTITIONSTORAGES

Returns a list of all partition storages in the current model with columns matching the schema rowset for partition storage objects. 
INFO.PARTITIONSTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.PERSPECTIVECOLUMNS

Returns a list of all perspective columns in the current model with columns matching the schema rowset for perspective columns objects. 
INFO.PERSPECTIVECOLUMNS ( [RestrictionName], [RestrictionValue], ... )

INFO.PERSPECTIVEHIERARCHIES

Returns a list of all perspective hierarchies in the current model with columns matching the schema rowset for perspective hierarchies objects. 
INFO.PERSPECTIVEHIERARCHIES ( [RestrictionName], [RestrictionValue], ... )

INFO.PERSPECTIVEMEASURES

Returns a list of all perspective measures in the current model with columns matching the schema rowset for perspective measures objects. 
INFO.PERSPECTIVEMEASURES ( [RestrictionName], [RestrictionValue], ... )

INFO.PERSPECTIVES

Returns a list of all perspectives in the current model with columns matching the schema rowset for perspectives objects. 
INFO.PERSPECTIVES ( [RestrictionName], [RestrictionValue], ... )

INFO.PERSPECTIVETABLES

Returns a list of all perspective tables in the current model with columns matching the schema rowset for perspective tables objects. 
INFO.PERSPECTIVETABLES ( [RestrictionName], [RestrictionValue], ... )

INFO.PROPERTIES

Represents the DISCOVER_PROPERTIES DMV query function. 
INFO.PROPERTIES ( [RestrictionName], [RestrictionValue], ... )

INFO.QUERYGROUPS

Returns rows from the TMSCHEMA_QUERY_GROUPS data management view. 
INFO.QUERYGROUPS ( [RestrictionName], [RestrictionValue], ... )

INFO.REFRESHPOLICIES

Returns rows from the TMSCHEMA_REFRESH_POLICIES data management view. 
INFO.REFRESHPOLICIES ( [RestrictionName], [RestrictionValue], ... )

INFO.RELATEDCOLUMNDETAILS

Returns rows from the TMSCHEMA_RELATED_COLUMN_DETAILS data management view. 
INFO.RELATEDCOLUMNDETAILS ( [RestrictionName], [RestrictionValue], ... )

INFO.RELATIONSHIPINDEXSTORAGES

Returns rows from the TMSCHEMA_RELATIONSHIP_INDEX_STORAGES data management view. 
INFO.RELATIONSHIPINDEXSTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.RELATIONSHIPS

Represents the TMSCHEMA_RELATIONSHIPS DMV query function. 
INFO.RELATIONSHIPS ( [RestrictionName], [RestrictionValue], ... )

INFO.RELATIONSHIPSTORAGES

Returns rows from the TMSCHEMA_RELATIONSHIP_STORAGES data management view. 
INFO.RELATIONSHIPSTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.ROLEMEMBERSHIPS

Returns a list of all role memberships in the current model with columns matching the schema rowset for role memberships objects. 
INFO.ROLEMEMBERSHIPS ( [RestrictionName], [RestrictionValue], ... )

INFO.ROLES

Returns a list of all roles in the current model with columns matching the schema rowset for roles objects. 
INFO.ROLES ( [RestrictionName], [RestrictionValue], ... )

INFO.SEGMENTMAPSTORAGES

Returns a list of all segment map storages in the current model with columns matching the schema rowset for segment map storage objects. 
INFO.SEGMENTMAPSTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.SEGMENTSTORAGES

Returns rows from the TMSCHEMA_SEGMENT_STORAGES data management view. 
INFO.SEGMENTSTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.STORAGEFILES

Returns a list of all storage files in the current model with columns matching the schema rowset for storage file objects. 
INFO.STORAGEFILES ( [RestrictionName], [RestrictionValue], ... )

INFO.STORAGEFOLDERS

Returns a list of all storage folders in the current model with columns matching the schema rowset for storage folder objects. 
INFO.STORAGEFOLDERS ( [RestrictionName], [RestrictionValue], ... )

INFO.STORAGETABLECOLUMNS

Returns statistics about the columns of in-memory tables. 
INFO.STORAGETABLECOLUMNS ( [RestrictionName], [RestrictionValue], ... )

INFO.STORAGETABLECOLUMNSEGMENTS

Returns information about the column segments used for storing data for in-memory tables. 
INFO.STORAGETABLECOLUMNSEGMENTS ( [RestrictionName], [RestrictionValue], ... )

INFO.STORAGETABLES

Returns statistics about in-memory tables. 
INFO.STORAGETABLES ( [RestrictionName], [RestrictionValue], ... )

INFO.TABLEPERMISSIONS

Returns a list of all table permissions in the current model with columns matching the schema rowset for table permissions objects. 
INFO.TABLEPERMISSIONS ( [RestrictionName], [RestrictionValue], ... )

INFO.TABLES

Returns a list of all tables in the current model with columns matching the schema rowset for table objects. 
INFO.TABLES ( [RestrictionName], [RestrictionValue], ... )

INFO.TABLESTORAGES

Returns a list of all table storages in the current model with columns matching the schema rowset for table storage objects. 
INFO.TABLESTORAGES ( [RestrictionName], [RestrictionValue], ... )

INFO.USERDEFINEDFUNCTIONS

Represents the TMSCHEMA_FUNCTIONS DMV query function. 
INFO.USERDEFINEDFUNCTIONS ( [RestrictionName], [RestrictionValue], ... )

INFO.VARIATIONS

Returns a list of all variations in the current model with columns matching the schema rowset for variations objects. 
INFO.VARIATIONS ( [RestrictionName], [RestrictionValue], ... )

INFO.VIEW.COLUMNS

Returns a list of all columns in the current model. 
INFO.VIEW.COLUMNS ( )

INFO.VIEW.MEASURES

Returns a list of all measures in the current model. 
INFO.VIEW.MEASURES ( )

INFO.VIEW.TABLES

Returns a list of all tables in the current model. 
INFO.VIEW.TABLES ( )

Inline Measure

DAX Editor command that replaces a measure reference with its expression.

InPerspective

Property that includes or excludes an object from a perspective.

INT

Rounds a number down to the nearest integer. 
INT ( Number )

Integer

DAX data type used by expressions and model metadata.

INTERSECT

Returns the rows of left-side table which appear in right-side table. 
INTERSECT ( LeftTable, RightTable )

INTRATE

Returns the interest rate for a fully invested security. 
INTRATE ( Settlement, Maturity, Investment, Redemption, [Basis] )

IPMT

Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. 
IPMT ( Rate, Per, Nper, Pv, [Fv], [Type] )

IsActive

A boolean value that indicates whether the relationship is marked as Active or Inactive.

ISAFTER

Returns true if the list of Value1 parameters compares strictly after the list of Value2 parameters. 
ISAFTER ( Value1, Value2, [Order], ... )

ISATLEVEL

Report whether the column is present at the current level. 
ISATLEVEL ( Column )

IsAvailableInMDX

A boolean value that indicates whether the column can be excluded from usage in MDX query tools.

ISBLANK

Checks whether a value is blank, and returns TRUE or FALSE. 
ISBLANK ( Value )

ISBOOLEAN

Checks whether a value is a boolean value (TRUE or FALSE), and returns TRUE or FALSE. This is an alias of ISLOGICAL. 
ISBOOLEAN ( Value )

ISCROSSFILTERED

Returns true when the specified table or column is crossfiltered. 
ISCROSSFILTERED ( TableNameOrColumnName )

ISCURRENCY

Checks whether a value is a fixed precision decimal number (currency), and returns TRUE or FALSE. This is an alias of ISDECIMAL. 
ISCURRENCY ( Value )

ISDATETIME

Checks whether a value is a Date/time, and returns TRUE or FALSE. 
ISDATETIME ( Value )

ISDECIMAL

Checks whether a value is a fixed precision decimal number (currency), and returns TRUE or FALSE. This is an alias of ISCURRENCY. 
ISDECIMAL ( Value )

IsDefault

If true, the Variation is the Default one for the Column.

IsDefaultImage

A boolean value that indicates whether this column is returned as the DefaultImage property in CSDL.

IsDefaultLabel

A boolean value that indicates whether this column is included in the DisplayKey element in CSDL.

ISDOUBLE

Checks whether a value is a floating-point decimal number, and returns TRUE or FALSE. 
ISDOUBLE ( Value )

IsDynamic

Indicates whether the set is static or dynamic

ISEMPTY

Returns true if the specified table or table-expression is Empty. 
ISEMPTY ( Table )

ISERROR

Checks whether a value is an error, and returns TRUE or FALSE. 
ISERROR ( Value )

ISEVEN

Returns TRUE if number is even, or FALSE if number is odd. 
ISEVEN ( Number )

ISFILTERED

Returns true when there are direct filters on the specified column. 
ISFILTERED ( TableNameOrColumnName )

IsHidden

Boolean property that hides an object from client visualization tools.

ISINSCOPE

Returns true when the specified column is the level in a hierarchy of levels. 
ISINSCOPE ( ColumnName )

ISINT64

Checks whether a value is an integer, and returns TRUE or FALSE. This is an alias of ISINTEGER. 
ISINT64 ( Value )

ISINTEGER

Checks whether a value is an integer, and returns TRUE or FALSE. This is an alias of ISINT64. 
ISINTEGER ( Value )

IsKey

A boolean value that indicates whether the column is a key of the table.

ISLOGICAL

Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE. This is an alias of ISBOOLEAN. 
ISLOGICAL ( Value )

IsNameInferred

A boolean value indicating whether name of the column is inferred by the server.

ISNONTEXT

Checks whether a value isn't text (blank cells are not text), and returns TRUE or FALSE. 
ISNONTEXT ( Value )

IsNullable

If false, the column cannot contain nulls.

ISNUMBER

Checks whether a value is a number, and returns TRUE or FALSE. 
ISNUMBER ( Value )

ISNUMERIC

Checks whether a value is an integer or decimal number, and returns TRUE or FALSE. 
ISNUMERIC ( Value )

ISO.CEILING

Rounds a number up, to the nearest integer or to the nearest multiple of significance. 
ISO.CEILING ( Number, [Significance] )

ISODD

Returns TRUE if number is odd, or FALSE if number is even. 
ISODD ( Number )

ISONORAFTER

The IsOnOrAfter function is a boolean function that emulates the behavior of Start At clause and returns true for a row that meets all the conditions mentioned as parameters in this function. 
ISONORAFTER ( Value1, Value2, [Order], ... )

ISPMT

Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments. 
ISPMT ( Rate, Per, Nper, Pv )

IsPrivate

A boolean value that specifies whether to hide a table from the client.

ISSELECTEDMEASURE

Returns true if one of the specified measures is currently being evaluated. 
ISSELECTEDMEASURE ( Measure, ... )

IsSimpleMeasure

A boolean value that indicates whether the measure is an implicit measure that is automatically created by client tools to aggregate a field.

ISSTRING

Checks whether a value is a string, and returns TRUE or FALSE. This is an alias of ISTEXT. 
ISSTRING ( Value )

ISSUBTOTAL

Returns TRUE if the current row contains a subtotal for a specified column and FALSE otherwise. 
ISSUBTOTAL ( ColumnName )

ISTEXT

Checks whether a value is text, and returns TRUE or FALSE. This is an alias of ISSTRING. 
ISTEXT ( Value )

IsUnique

A boolean value that indicates whether the column contains only unique values.

J

JoinOnDateBehavior

When joining two date time columns, indicates whether to join on date and time parts, or on date part only.

K

KEEPFILTERS

Changes the CALCULATE and CALCULATETABLE function filtering semantics. 
KEEPFILTERS ( Expression )

KeepUniqueRows

Specifies the grouping behavior used for building a hierarchy.

KEYWORDMATCH

Returns TRUE if there is a match between the MatchExpression and Text. 
KEYWORDMATCH ( MatchExpression, Text )

KPI

Key Performance Indicator; metric tracking performance against a meaningful target.

KQL

Kusto Query Language; query language for logs, telemetry, and event data.

L

Lakehouse

Data architecture combining data lake storage with warehouse-style analytics.

LAST

The Last function retrieves a value in the Visual Calculation data grid from the last row of an axis. 
LAST ( Column, [Axis], [OrderBy], [Blanks], [Reset] )

LASTDATE

Returns last non blank date. 
LASTDATE ( Dates )

LASTNONBLANK

Returns the last value in the column for which the expression has a non blank value. 
LASTNONBLANK ( ColumnName, Expression )

LASTNONBLANKVALUE

Returns the last non blank value of the expression that evaluated for the column. 
LASTNONBLANKVALUE ( ColumnName, Expression )

LCM

Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of both integer arguments number1, number2. Use LCM to add fractions with different denominators. 
LCM ( Number1, Number2 )

LEFT

Returns the specified number of characters from the start of a text string. 
LEFT ( Text, [NumberOfCharacters] )

LegacyRedirects

Whether unsafe legacy redirects from HTTPS to HTTP should be enabled

LEN

Returns the number of characters in a text string. 
LEN ( Text )

Less than (<)

DAX operator used to combine, compare, or transform values.

LineageTag

Tag that identifies object lineage across metadata changes.

LINEST

Uses the Least Squares method to calculate a straight line that best fits the data, then returns a table describing the line. The equation for the line is of the form: y = m1*x1 + m2*x2 + ... + b. 
LINEST ( ColumnY, ColumnX, ..., [Const] )

LINESTX

Uses the Least Squares method to calculate a straight line that best fits the data, then returns a table describing the line. The data result from expressions evaluated for each row in a table. 
LINESTX ( Table, ExpressionY, ExpressionX, ..., [Const] )

LLM

Large Language Model; model trained to understand and generate language.

LN

Returns the natural logarithm of a number. 
LN ( Number )

LOG

Returns the logarithm of a number to the base you specify. 
LOG ( Number, [Base] )

LOG10

Returns the base-10 logarithm of a number. 
LOG10 ( Number )

LOOKUP

Identifies cells where specified columns match evaluated expressions, and retrieves a column value (only when a single cell is identified) or calculates an expression's value from those matching cells. Filter context from columns not specified will be applied implicitly. 
LOOKUP ( Result_ColumnOrExpression, Search_Column, Search_Value, ... )

LOOKUPVALUE

Retrieves a value from a table. 
LOOKUPVALUE ( Result_ColumnName, Search_ColumnName, Search_Value, ..., [Alternate_Result] )

LOOKUPWITHTOTALS

Identifies cells where specified columns match evaluated expressions, and retrieves a column value (only when a single cell is identified) or calculates an expression's value from those matching cells. LOOKUPWITHTOTALS defaults the non-specified columns to the total, whereas LOOKUP doesn't change the filter over non-specified columns. 
LOOKUPWITHTOTALS ( Result_ColumnOrExpression, Search_Column, Search_Value, ... )

LOWER

Converts all letters in a text string to lowercase. 
LOWER ( Text )

M

many-to-many

Relationship pattern where both sides can contain repeated keys.

MATCHBY

The columns used to determine how to match data and identify the current row. Can only be used within a Window function. 
MATCHBY ( [MatchBy_ColumnName], ... )

MAX

Returns the largest value in a column, or the larger value between two scalar expressions. Ignores logical values. Strings are compared according to alphabetical order. 
MAX ( ColumnNameOrScalar1, [Scalar2] )

MAXA

Returns the largest value in a column. doesn't ignore logical values and text. 
MAXA ( ColumnName )

MaxConnections

The maximum number of connections to be opened concurrently to the data source.

MaxParallelismPerRefresh

Determines the max possible number of parallel tasks in data refresh, within the resource constraints of the hosting service.

MAXX

Returns the largest value that results from evaluating an expression for each row of a table. Strings are compared according to alphabetical order. 
MAXX ( Table, Expression, [Variant] )

MCP

Model Context Protocol; standard for connecting AI applications to tools and data.

MCP server

Model Context Protocol server; exposes tools, data, or prompts.

MDURATION

Returns the modified Macauley duration for a security with an assumed par value of $100. 
MDURATION ( Settlement, Maturity, Coupon, Yld, Frequency, [Basis] )

MDX

MultiDimensional eXpressions; query language for multidimensional analytical models.

MEASURE

DAX statement keyword used to shape queries and calculations.

MEDIAN

Returns the 50th percentile of values in a column. 
MEDIAN ( Column )

MEDIANX

Returns the 50th percentile of an expression values in a table. 
MEDIANX ( Table, Expression )

MemberName

The security name that identifies the user or group of the member.

MemberType

Indicates whether the particular member of a security role is an individual user or a group of users, or automatically detected.

MetadataAccessPolicy

The policy that applies to the users with read permissions only and controls their access to various metadata elements.

Metric View

Semantic model artifact in Databricks Unity Catalog. Defines tables, columns, relationships (joins), and measures (SQL) in YAML.

MExpression

The Power Query (M) Expression used to populate the partition with data.

Microsoft Graph

Microsoft API for identity, users, groups, and organizational data.

MID

Returns a string of characters from the middle of a text string, given a starting position and length. 
MID ( Text, StartPosition, NumberOfCharacters )

MIN

Returns the smallest value in a column, or the smaller value between two scalar expressions. Ignores logical values. Strings are compared according to alphabetical order. 
MIN ( ColumnNameOrScalar1, [Scalar2] )

MINA

Returns the smallest value in a column. doesn't ignore logical values and text. 
MINA ( ColumnName )

MINUTE

Returns a number from 0 to 59 representing the minute. 
MINUTE ( Datetime )

MINX

Returns the smallest value that results from evaluating an expression for each row of a table. Strings are compared according to alphabetical order. 
MINX ( Table, Expression, [Variant] )

MOD

Returns the remainder after a number is divided by a divisor. 
MOD ( Number, Divisor )

MONTH

Returns a number from 1 (January) to 12 (December) representing the month. 
MONTH ( Date )

MOVINGAVERAGE

Calculates a moving average along the specified axis of the Visual Calculation data grid. 
MOVINGAVERAGE ( Column, WindowSize, [IncludeCurrent], [Axis], [OrderBy], [Blanks], [Reset] )

MPARAMETER

DAX statement keyword used to shape queries and calculations.

MROUND

Returns a number rounded to the desired multiple. 
MROUND ( Number, Multiple )

MultipleOrEmptySelectionDescription

The description of the CalculationGroupExpression, visible to developers at design time and to administrators in management tools, such as SQL Server Management Studio.

MultipleOrEmptySelectionExpression

The expression defined on this object will be applied to the selected measure in DAX queries, when multiple calculation items are applied.

N

NAMEOF

Returns the name of a table, column, measure, or calendar as a text string. Optional parameters control which component of the name is returned and how the result is escaped. 
NAMEOF ( Value, [Component], [Escaped] )

NATURALINNERJOIN

Joins the Left table with right table using the Inner Join semantics. 
NATURALINNERJOIN ( LeftTable, RightTable )

NATURALJOINUSAGE

Adds a table as Natural Join into filter context. 
NATURALJOINUSAGE ( Expression )

NATURALLEFTOUTERJOIN

Joins the Left table with right table using the Left Outer Join semantics. 
NATURALLEFTOUTERJOIN ( LeftTable, RightTable )

NETWORKDAYS

Returns the number of whole workdays between two dates (inclusive) using parameters to indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays. 
NETWORKDAYS ( start_date, end_date, [weekend], [holidays] )

NEXT

The Next function retrieves a value in the next row of an axis in the Visual Calculation data grid. 
NEXT ( Column, [Steps], [Axis], [OrderBy], [Blanks], [Reset] )

NEXTDAY

Returns a next day. 
NEXTDAY ( Dates )

NEXTMONTH

Returns a next month. 
NEXTMONTH ( Dates )

NEXTQUARTER

Returns a next quarter. 
NEXTQUARTER ( Dates )

NEXTWEEK

Returns a next week. 
NEXTWEEK ( Calendar )

NEXTYEAR

Returns a next year. 
NEXTYEAR ( Dates, [YearEndDate] )

NOMINAL

Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year. 
NOMINAL ( Effect_rate, Npery )

NONFILTER

Modifies how filters are applied while evaluating a GROUPCROSSAPPLY or GROUPCROSSAPPLYTABLE function. 
NONFILTER ( TableExpression )

NONVISUAL

Mark the filter as NonVisual. 
NONVISUAL ( Expression )

NORM.DIST

Returns the normal distribution for the specified mean and standard deviation. 
NORM.DIST ( X, Mean, Standard_dev, Cumulative )

NORM.INV

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. 
NORM.INV ( Probability, Mean, Standard_dev )

NORM.S.DIST

Returns the standard normal distribution (has a mean of zero and a standard deviation of one). 
NORM.S.DIST ( Z, Cumulative )

NORM.S.INV

Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one. 
NORM.S.INV ( Probability )

NoSelectionExpression

The expression defined on this object will be applied to the selected measure in DAX queries, when no calculation items are applied.

NoSelectionExpressionDescription

The description of the CalculationGroupExpression, visible to developers at design time and to administrators in management tools, such as SQL Server Management Studio.

NoSelectionFormatStringExpression

The format string expression defined on this object will be applied to the selected measure in DAX queries, when no calculation items are applied.

NOT

Changes FALSE to TRUE, or TRUE to FALSE. 
NOT ( Logical )

notebook

Interactive code document for data engineering and automation tasks.

NOW

Returns the current date and time in datetime format. 
NOW ( )

NPER

Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. 
NPER ( Rate, Pmt, Pv, [Fv], [Type] )

O

ODBC

Open DataBase Connectivity; standard connectivity layer used by client tools.

ODD

Returns number rounded up to the nearest odd integer. 
ODD ( Number )

ODDFPRICE

Returns the price per $100 face value of a security having an odd (short or long) first period. 
ODDFPRICE ( Settlement, Maturity, Issue, First_coupon, Rate, Yld, Redemption, Frequency, [Basis] )

ODDFYIELD

Returns the yield of a security that has an odd (short or long) first period. 
ODDFYIELD ( Settlement, Maturity, Issue, First_coupon, Rate, Pr, Redemption, Frequency, [Basis] )

ODDLPRICE

Returns the price per $100 face value of a security having an odd (short or long) last period. 
ODDLPRICE ( Settlement, Maturity, Last_interest, Rate, Yld, Redemption, Frequency, [Basis] )

ODDLYIELD

Returns the yield of a security that has an odd (short or long) last period. 
ODDLYIELD ( Settlement, Maturity, Last_interest, Rate, Pr, Redemption, Frequency, [Basis] )

OFFSET

Retrieves a single row from a relation by moving a number of rows within the specified partition, sorted by the specified order or on the axis specified. 
OFFSET ( Delta, [Relation], [OrderBy], [Blanks], [PartitionBy], [MatchBy], [Reset] )

OLE DB

Object Linking and Embedding DB; COM interface layer for diverse data sources.

OLS

Object-Level Security; security rules that hide tables or columns from users.

OneLake

Tenant-wide Fabric data lake for analytics and AI workloads.

OPENINGBALANCEMONTH

Evaluates the specified expression for the date corresponding to the end of the previous month after applying specified filters. 
OPENINGBALANCEMONTH ( Expression, Dates, [Filter] )

OPENINGBALANCEQUARTER

Evaluates the specified expression for the date corresponding to the end of the previous quarter after applying specified filters. 
OPENINGBALANCEQUARTER ( Expression, Dates, [Filter] )

OPENINGBALANCEWEEK

Evaluates the specified expression for the date corresponding to the end of the previous week after applying specified filters. 
OPENINGBALANCEWEEK ( Expression, Calendar, [Filter] )

OPENINGBALANCEYEAR

Evaluates the specified expression for the date corresponding to the end of the previous year after applying specified filters. 
OPENINGBALANCEYEAR ( Expression, Dates, [Filter], [YearEndDate] )

OR

Returns TRUE if any of the arguments are TRUE, and returns FALSE if all arguments are FALSE. 
OR ( Logical1, Logical2 )

Or (||)

DAX operator used to combine, compare, or transform values.

ORDER BY

DAX statement keyword used to shape queries and calculations.

ORDERBY

The expressions and order directions used to determine the sort order within each partition. Can only be used within a Window function. 
ORDERBY ( [OrderBy_Expression], [OrderBy_Direction], ... )

Ordinal

The zero-based ordinal value associated with a Calculation Item.

P

PARALLELPERIOD

Returns a parallel period of dates by the given set of dates and a specified interval. 
PARALLELPERIOD ( Dates, NumberOfIntervals, Interval )

Parquet

Columnar file format optimized for analytical storage and queries.

PARTITIONBY

The columns used to determine how to partition the data. Can only be used within a Window function. 
PARTITIONBY ( [PartitionBy_ColumnName], ... )

PATH

Returns a string which contains a delimited list of IDs, starting with the top/root of a hierarchy and ending with the specified ID. 
PATH ( ID_ColumnName, Parent_ColumnName )

PATHCONTAINS

Returns TRUE if the specified Item exists within the specified Path. 
PATHCONTAINS ( Path, Item )

PATHITEM

Returns the nth item in the delimited list produced by the Path function. 
PATHITEM ( Path, Position, [Type] )

PATHITEMREVERSE

Returns the nth item in the delimited list produced by the Path function, counting backwards from the last item in the path. 
PATHITEMREVERSE ( Path, Position, [Type] )

PATHLENGTH

Returns returns the number of items in a particular path string. This function returns 1 for the path generated for an ID at the top/root of a hierarchy. 
PATHLENGTH ( Path )

PBIP

Power BI Project; folder format for source control.

PBIR

Power BI report; enhanced metadata format for reports.

PBIT

Power BI template; Desktop template format for reusable reports.

PBIX

Power BI file containing reports, models, and optional imported data.

PDURATION

Returns the number of periods required by an investment to reach a specified value. 
PDURATION ( Rate, Pv, Fv )

Peek Definition

DAX Editor command for viewing referenced object definitions inline.

PERCENTILE.EXC

Returns the k-th (exclusive) percentile of values in a column. 
PERCENTILE.EXC ( Column, K )

PERCENTILE.INC

Returns the k-th (inclusive) percentile of values in a column. 
PERCENTILE.INC ( Column, K )

PERCENTILEX.EXC

Returns the k-th (exclusive) percentile of an expression values in a table. 
PERCENTILEX.EXC ( Table, Expression, K )

PERCENTILEX.INC

Returns the k-th (inclusive) percentile of an expression values in a table. 
PERCENTILEX.INC ( Table, Expression, K )

PERMUT

Returns the number of permutations for a given number of objects that can be selected from number objects. A permutation is any set or subset of objects or events where internal order is significant. Permutations are different from combinations, for which the internal order isn't significant. Use this function for lottery-style probability calculations. 
PERMUT ( Number, Number_chosen )

Perspective

Model viewpoint that exposes a curated subset of objects to users.

PI

Returns the value of π, 3.14159265358979, accurate to 15 digits. 
PI ( )

Pivot Grid

Tabular Editor grid for browsing results and debugging measure cells.

PMT

Calculates the payment for a loan based on constant payments and a constant interest rate. 
PMT ( Rate, Nper, Pv, [Fv], [Type] )

POISSON.DIST

Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute. 
POISSON.DIST ( X, Mean, Cumulative )

PolicyType

Specifies the type of the refresh policy

PollingExpression

If not null, M expression that is evaluated and stored for each partition upon each refresh or merge operation.

POWER

Returns the result of a number raised to a power. 
POWER ( Number, Power )

Power Query M

Functional language that defines Power Query data mashups.

PPMT

Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate. 
PPMT ( Rate, Per, Nper, Pv, [Fv], [Type] )

Precedence

Defines an evaluation order of CalculationGroup objects.

PREVIOUS

The Previous function retrieves a value in the previous row of an axis in the Visual Calculation data grid. 
PREVIOUS ( Column, [Steps], [Axis], [OrderBy], [Blanks], [Reset] )

PREVIOUSDAY

Returns a previous day. 
PREVIOUSDAY ( Dates )

PREVIOUSMONTH

Returns a previous month. 
PREVIOUSMONTH ( Dates )

PREVIOUSWEEK

Returns a previous week. 
PREVIOUSWEEK ( Calendar )

PREVIOUSYEAR

Returns a previous year. 
PREVIOUSYEAR ( Dates, [YearEndDate] )

PRICE

Returns the price per $100 face value of a security that pays periodic interest. 
PRICE ( Settlement, Maturity, Rate, Yld, Redemption, Frequency, [Basis] )

PRICEDISC

Returns the price per $100 face value of a discounted security. 
PRICEDISC ( Settlement, Maturity, Discount, Redemption, [Basis] )

PRICEMAT

Returns the price per $100 face value of a security that pays interest at maturity. 
PRICEMAT ( Settlement, Maturity, Issue, Rate, Yld, [Basis] )

PrimaryColumn

The reference to the primary column in the association.

PrivacySetting

Privacy setting from PrivacyClass or null if it's not present in the Credential property.

PRODUCT

Returns the product of given column reference. 
PRODUCT ( ColumnName )

PRODUCTX

Returns the product of an expression values in a table. 
PRODUCTX ( Table, Expression )

prompt injection

Attack that manipulates an AI system through malicious instructions.

PV

calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that's your investment goal. 
PV ( Rate, Nper, Pmt, [Fv], [Type] )

Q

QUARTER

Returns a number from 1 (January-March) to 4 (October-December) representing the quarter. 
QUARTER ( Date )

QueryGroup

QueryGroup associated with the expression.

quick measure

Power BI feature that generates common DAX measures.

QUOTIENT

Returns the integer portion of a division. 
QUOTIENT ( Numerator, Denominator )

R

RADIANS

Converts degrees to radians. 
RADIANS ( Number )

RAG

Retrieval-Augmented Generation; pattern that retrieves context before generating answers.

RAND

Returns a random number greater than or equal to 0 and less than 1, evenly distributed. Random numbers change on recalculation. 
RAND ( )

RANDBETWEEN

Returns a random number between the numbers you specify. 
RANDBETWEEN ( Bottom, Top )

RANGE

Retrieves a range of rows within the specified axis, relative to the current row. 
RANGE ( Step, [IncludeCurrent], [Axis], [OrderBy], [Blanks], [Reset] )

RANK

Returns the rank for the current context within the specified partition sorted by the specified order or on the axis specified. 
RANK ( [Ties], [Relation], [OrderBy], [Blanks], [PartitionBy], [MatchBy], [Reset] )

RANK.EQ

Returns the rank of a number in a column of numbers. If more than one value has the same rank, the top rank of that set of values is returned. 
RANK.EQ ( Value, ColumnName, [Order] )

RANKX

Returns the rank of an expression evaluated in the current context in the list of values for the expression evaluated for each row in the specified table. 
RANKX ( Table, Expression, [Value], [Order], [Ties] )

RATE

Returns the interest rate per period of an annuity. RATE is calculated by iteration and can have zero or more solutions. If the successive results of RATE do not converge to within 0.0000001 after 20 iterations, RATE returns an error. 
RATE ( Nper, Pmt, Pv, [Fv], [Type], [Guess] )

Rayfin CLI

Rayfin CLI for developing and deploying Fabric apps.

RECEIVED

Returns the amount received at maturity for a fully invested security. 
RECEIVED ( Settlement, Maturity, Investment, Discount, [Basis] )

Refresh policy

Table rule that creates and updates partitions during refresh.

refresh policy

Rules that define how incremental refresh partitions and reloads model data.

RefreshBookmark

The refresh bookmark of the refresh policy for this partition

RELATED

Returns a related value from another table. 
RELATED ( ColumnName )

RELATEDTABLE

Returns the related tables filtered so that it only includes the related rows. 
RELATEDTABLE ( Table )

Release Pipeline

Azure DevOps pipeline for deploying build artifacts across stages.

RemoteParameterName

The parameter name defined in source model, applicable only for proxy model and empty for local model.

REMOVEFILTERS

Clear filters from the specified tables or columns. 
REMOVEFILTERS ( [TableNameOrColumnName], [ColumnName], ... )

REPLACE

Replaces part of a text string with a different text string. 
REPLACE ( OldText, StartPosition, NumberOfCharacters, NewText )

REPT

Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. 
REPT ( Text, NumberOfTimes )

RETURN

DAX statement keyword used to shape queries and calculations.

ReturnErrorValuesAsNull

Whether individual query errors should be returned as nulls in the query result instead of failing the query

RIGHT

Returns the specified number of characters from the end of a text string. 
RIGHT ( Text, [NumberOfCharacters] )

RLE

Run-Length Encoding; compression technique used by columnar storage engines.

RLS

Row-Level Security; security rules that filter rows for different users.

ROLLUP

Identifies a subset of columns specified in the call to SUMMARIZE function that should be used to calculate subtotals. 
ROLLUP ( GroupBy_ColumnName, ... )

ROLLUPADDISSUBTOTAL

Identifies a subset of columns specified in the call to SUMMARIZECOLUMNS function that should be used to calculate groups of subtotals. 
ROLLUPADDISSUBTOTAL ( [GrandtotalFilter], GroupBy_ColumnName, Name, [GroupLevelFilter], ... )

ROLLUPGROUP

Identifies a subset of columns specified in the call to SUMMARIZE or SUMMARIZECOLUMNS function that should be used to calculate groups of subtotals. 
ROLLUPGROUP ( GroupBy_ColumnName, ... )

ROLLUPISSUBTOTAL

Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL. 
ROLLUPISSUBTOTAL ( [GrandtotalFilter], GroupBy_ColumnName, IsSubtotal_ColumnName, [GroupLevelFilter], ... )

ROUND

Rounds a number to a specified number of digits. 
ROUND ( Number, NumberOfDigits )

ROUNDDOWN

Rounds a number down, toward zero. 
ROUNDDOWN ( Number, NumberOfDigits )

ROUNDUP

Rounds a number up, away from zero. 
ROUNDUP ( Number, NumberOfDigits )

ROW

Returns a single row table with new columns specified by the DAX expressions. 
ROW ( Name, Expression, ... )

row context

DAX evaluation state for the current row during iteration.

RowLevelSecurity

Role property containing table filters for row-level security.

ROWNUMBER

Returns the unique rank for the current context within the specified partition sorted by the specified order or on the axis specified. 
ROWNUMBER ( [Relation], [OrderBy], [Blanks], [PartitionBy], [MatchBy], [Reset] )

RRI

Returns an equivalent interest rate for the growth of an investment. 
RRI ( Nper, Pv, Fv )

RUNNINGSUM

Calculates a running sum along the specified axis of the Visual Calculation data grid. 
RUNNINGSUM ( Column, [Axis], [OrderBy], [Blanks], [Reset] )

S

SAMEPERIODLASTYEAR

Returns a set of dates in the current selection from the previous year. 
SAMEPERIODLASTYEAR ( Dates )

SAMPLE

Returns a sample subset from a given table expression. 
SAMPLE ( Size, Table, OrderBy, [Order], ... )

SAMPLEAXISWITHLOCALMINMAX

Returns a subset from a table expression that is obtained by binning the primary X-Axis into equal-sized bins and then preserving the local min/max for each bin across different series. 
SAMPLEAXISWITHLOCALMINMAX ( Size, Table, Axis, Measure, ..., MinResolution, [DynamicSeries], ..., [DynamicSeriesSelectionCriteria], [DynamicSeriesSelectionOrder], [MaxResolution], [MaxDynamicSeries], [MaxIterations] )

SAMPLECARTESIANPOINTSBYCOVER

Returns a sample subset from a given table expression that is obtained by plotting the rows as points in a 2D space, based on the input coordinates and radius columns, and then removing overlapping points. 
SAMPLECARTESIANPOINTSBYCOVER ( Size, Table, XAxis, YAxis, [Radius], [MaxMinRatio], [MaxBlankRatio] )

SEARCH

Returns the starting position of one text string within another text string. SEARCH isn't case-sensitive, but it is accent-sensitive. 
SEARCH ( FindText, WithinText, [StartPosition], [NotFoundValue] )

SECOND

Returns a number from 0 to 59 representing the second. 
SECOND ( Datetime )

SecurityFilteringBehavior

Indicates how relationships influence filtering of data when evaluating row-level security expressions.

SELECTCOLUMNS

Returns a table with selected columns from the table and new columns specified by the DAX expressions. 
SELECTCOLUMNS ( Table, [Name], Expression, ... )

SELECTEDMEASURE

Returns the measure that is currently being evaluated. 
SELECTEDMEASURE ( )

SELECTEDMEASURENAME

Returns name of the measure that is currently being evaluated. 
SELECTEDMEASURENAME ( )

SELECTEDVALUE

Returns the value when there's only one value in the specified column, otherwise returns the alternate result. 
SELECTEDVALUE ( ColumnName, [AlternateResult] )

Semantic Bridge

Tabular Editor feature for importing metric views into semantic models.

Semantic layer

Business-facing layer that gives data consistent meaning across tools.

Semantic Link

Fabric library for using semantic models from notebooks.

Semantic model

Structured business layer for tables, relationships, calculations, and security.

SemPy

Python library behind Semantic Link in Fabric notebooks.

service principal

Application identity used for unattended authentication and automation.

SHADOWCLUSTER

Modifies how filters are applied while evaluating a GROUPCROSSAPPLY or GROUPCROSSAPPLYTABLE function. 
SHADOWCLUSTER ( TableExpression )

ShowAsVariationsOnly

A boolean value that indicates a difference between a local and server version.

SIGN

Returns the sign of a number: 1 if the number is positive, zero if the number is zero, or -1 if the number is negative. 
SIGN ( Number )

SIN

Returns the sine of the given angle. 
SIN ( Number )

SINH

Returns the hyperbolic sine of a number. 
SINH ( Number )

slicer

Power BI visual that filters other report visuals.

SLN

Returns the straight-line depreciation of an asset for one period. 
SLN ( Cost, Salvage, Life )

snowflake schema

Dimensional model where dimensions are normalized into related tables.

SortByColumn

Indicates that the column defining this property will be sorted by the values of the column referenced by this property.

Source control

Practice of tracking and reviewing changes over time.

SourceColumn

Name of the column from which data will be retrieved.

SourceExpression

M expression that is used as the source M expression for new partitions.

SourceProviderType

The original data type of the column as defined in the language of the data source.

SourceQueryCulture

The name of the Culture used for formatting during refresh through Mashup.

SourceType

The type of source used by the Partition.

SQL endpoint

Access surface for querying lakehouse tables with SQL.

SQRT

Returns the square root of a number. 
SQRT ( Number )

SQRTPI

Returns the square root of (number * pi). 
SQRTPI ( Number )

SSAS

SQL Server Analysis Services; Microsoft analytical engine behind tabular models.

SSDT

SQL Server Data Tools; Visual Studio tools for database and BI projects.

SSMS

SQL Server Management Studio; Microsoft tool for managing SQL Server and Analysis Services.

Star schema

Model design with fact tables surrounded by dimension tables.

START AT

DAX statement keyword used to shape queries and calculations.

STARTOFMONTH

Returns the start of month. 
STARTOFMONTH ( Dates )

STARTOFQUARTER

Returns the start of quarter. 
STARTOFQUARTER ( Dates )

STARTOFWEEK

Returns the start of week. 
STARTOFWEEK ( Calendar )

STARTOFYEAR

Returns the start of year. 
STARTOFYEAR ( Dates, [YearEndDate] )

StatusExpression

An expression that is used to calculate the status of the KPI.

StatusGraphic

The recommended graphic to represent the status of this KPI.

STDEV.P

Calculates standard deviation based on the entire population given as arguments. Ignores logical values and text. 
STDEV.P ( ColumnName )

STDEV.S

Estimates standard deviation based on a sample. Ignores logical values and text in the sample. 
STDEV.S ( ColumnName )

STDEVX.P

Estimates standard deviation based on the entire population that results from evaluating an expression for each row of a table. 
STDEVX.P ( Table, Expression )

STDEVX.S

Estimates standard deviation based on a sample that results from evaluating an expression for each row of a table. 
STDEVX.S ( Table, Expression )

storage mode

Model setting that controls how Power BI accesses data.

String

DAX data type used by expressions and model metadata.

StringIndex

This property allows building and persisting of string column's index.

SUBSTITUTE

Replaces existing text with new text in a text string. 
SUBSTITUTE ( Text, OldText, NewText, [InstanceNumber] )

SUBSTITUTEWITHINDEX

Returns a table which represents the semijoin of two tables supplied and for which the common set of columns are replaced by a 0-based index column. The index is based on the rows of the second table sorted by specified order expressions. 
SUBSTITUTEWITHINDEX ( Table, Name, SemiJoinIndexTable, Expression, [Order], ... )

Subtraction (-)

DAX operator used to combine, compare, or transform values.

SUM

Adds all the numbers in a column. 
SUM ( ColumnName )

Summarization

A value indicating the summarization type used by this alternative sources' column.

SUMMARIZE

Creates a summary of the input table grouped by the specified columns. 
SUMMARIZE ( Table, [GroupBy_ColumnName], [Name], [Expression], ... )

SummarizeBy

A value indicating the default function, if any, used to aggregate this field.

SUMMARIZECOLUMNS

Create a summary table for the requested totals over set of groups. 
SUMMARIZECOLUMNS ( [GroupBy_ColumnName], [FilterTable], [Name], [Expression], ... )

SUMX

Returns the sum of an expression evaluated for each row in a table. 
SUMX ( Table, Expression )

SVG

Scalable Vector Graphics; XML-based format for scalable two-dimensional vector images.

SWITCH

Returns different results depending on the value of an expression. 
SWITCH ( Expression, Value, Result, ..., [Else] )

SYD

Returns the sum-of-years' digits depreciation of an asset for a specified period. 
SYD ( Cost, Salvage, Life, Per )

SystemManaged

A boolean value that indicates whether the table is managed by the system.

T

T.DIST

Returns the Student's left-tailed t-distribution. 
T.DIST ( X, Deg_freedom, Cumulative )

T.DIST.2T

Returns the two-tailed Student's t-distribution. 
T.DIST.2T ( X, Deg_freedom )

T.DIST.RT

Returns the right-tailed Student's t-distribution. 
T.DIST.RT ( X, Deg_freedom )

T.INV

Returns the left-tailed inverse of the Student's t-distribution. 
T.INV ( Probability, Deg_freedom )

T.INV.2T

Returns the two-tailed inverse of the Student's t-distribution. 
T.INV.2T ( Probability, Deg_freedom )

TABLE

DAX statement keyword used to shape queries and calculations.

Table Group

Tabular Editor grouping feature for organizing related tables.

TableDetailPosition

Determines whether you can place this column in the DefaultDetails collection of the Table.

TableGroup

The name of the Table Group in which this table is displayed (Tabular Editor only)

TABLEOF

Returns the table that the specified column, measure, or calendar belongs to. 
TABLEOF ( Reference )

Tabular model

Analysis Services model type organized as tables, relationships, and DAX.

TAN

Returns the tangent of the given angle. 
TAN ( Number )

TANH

Returns the hyperbolic tangent of a number. 
TANH ( Number )

TargetExpression

An expression that evaluates to a number and indicates the goal for the KPI.

TargetFormatString

The format string to be used when presenting the target value for the KPI.

TBILLEQ

Returns the bond-equivalent yield for a Treasury bill. 
TBILLEQ ( Settlement, Maturity, Discount )

TBILLPRICE

Returns the price per $100 face value for a Treasury bill. 
TBILLPRICE ( Settlement, Maturity, Discount )

TBILLYIELD

Returns the yield for a Treasury bill. 
TBILLYIELD ( Settlement, Maturity, Pr )

TE CLI

Tabular Editor CLI for semantic model automation.

TIME

Converts hours, minutes, and seconds given as numbers to a time in datetime format. 
TIME ( Hour, Minute, Second )

TIMEVALUE

Converts a time in text format to a time in datetime format. 
TIMEVALUE ( TimeText )

TMDL

Tabular Model Definition Language; readable metadata format for tabular semantic models.

TMDL View

Tabular Model Definition Language view; Power BI Desktop window for metadata scripting.

TMSL

Tabular Model Scripting Language; scripting language for managing tabular metadata.

ToCardinality

Indicates whether the "To" end of the relationship has a cardinality of One (1) or Many (2).

ToColumn

The destination column in a single column relationship.

TOCSV

Converts the records of a table into a CSV (comma-separated values) text. 
TOCSV ( Table, [MaxRows], [Delimiter], [IncludeHeaders] )

TODAY

Returns the current date in datetime format. 
TODAY ( )

TOJSON

Converts the records of a table into a JSON text. 
TOJSON ( Table, [MaxRows] )

TOM

Tabular Object Model; programming interface for reading and changing tabular models.

TOM Explorer

Tabular Object Model Explorer; tree view for semantic model objects.

TOPN

Returns a given number of top rows according to a specified expression. 
TOPN ( N_Value, Table, [OrderBy_Expression], [Order], ... )

TOPNPERLEVEL

Returns top rows per logical level from a table expression. 
TOPNPERLEVEL ( Rows, Table, LevelsDefinition, NodesExpanded, LevelsBoundaries, RestartIndicatorColumnName )

TOPNSKIP

Retrieves a number of rows from a table efficiently, skipping a number of rows. Compared to TOPN, the TOPNSKIP function is less flexible, but much faster. 
TOPNSKIP ( N_Value, Skip_Rows_Value, Table, [OrderBy_Expression], [Order], ..., [Ties] )

ToTable

The destination table in a directional table relationship.

TOTAL

DAX statement keyword used to shape queries and calculations.

TOTALMTD

Evaluates the specified expression over the interval which begins on the first of the month and ends with the last date in the specified date column (or in the evaluation context if a calendar reference is provided) after applying specified filters. 
TOTALMTD ( Expression, Dates, [Filter] )

TOTALQTD

Evaluates the specified expression over the interval which begins on the first day of the quarter and ends with the last date in the specified date column (or in the evaluation context if a calendar reference is provided) after applying specified filters. 
TOTALQTD ( Expression, Dates, [Filter] )

TOTALWTD

Evaluates the specified expression over the interval which begins on the first day of the week and ends with the last date in the evaluation context after applying specified filters. 
TOTALWTD ( Expression, Calendar, [Filter] )

TOTALYTD

Evaluates the specified expression over the interval which begins on the first day of the year and ends with the last date in the specified date column (or in the evaluation context if a calendar reference is provided) after applying specified filters. 
TOTALYTD ( Expression, Dates, [Filter], [YearEndDate] )

TREATAS

Treats the columns of the input table as columns from other tables. For each column, filters out any values that are not present in its respective output column. 
TREATAS ( Expression, ColumnName, ... )

TrendGraphic

A string that identifies the graphic to show for the trend of the KPI.

TRIM

Removes all spaces from a text string except for single spaces between words. 
TRIM ( Text )

TRUE

Returns the logical value TRUE. 
TRUE ( )

TRUNC

Truncates a number to an integer by removing the decimal, or fractional, part of the number. 
TRUNC ( Number, [NumberOfDigits] )

U

UNICHAR

Returns the Unicode character that is referenced by the given numeric value. 
UNICHAR ( Number )

UNICODE

Returns the number (code point) corresponding to the first character of the text. 
UNICODE ( Text )

UNION

Returns the union of the tables whose columns match. 
UNION ( Table, ... )

Unity Catalog

Governance layer for data assets, semantic metadata, and lineage.

Update Table Schema

Tabular Editor feature for refreshing model columns from source metadata.

UPPER

Converts a text string to all uppercase letters. 
UPPER ( Text )

USERCULTURE

Returns the culture code for the user, based on their operating system or browser settings. 
USERCULTURE ( )

USERELATIONSHIP

Specifies an existing relationship to be used in the evaluation of a DAX expression. The relationship is defined by naming, as arguments, the two columns that serve as endpoints. 
USERELATIONSHIP ( ColumnName1, ColumnName2 )

USERNAME

Returns the domain name and user name of the current connection with the format of domain-name\user-name. 
USERNAME ( )

USEROBJECTID

Returns the current user's Object ID from Azure AD for Azure Analysis Server and the current user's SID for on-premise Analysis Server. 
USEROBJECTID ( )

UTCNOW

Returns the current date and time in datetime format expressed in Coordinated Universal Time (UTC). 
UTCNOW ( )

UTCTODAY

Returns the current date in datetime format expressed in Coordinated Universal Time (UTC). 
UTCTODAY ( )

V

VALUE

Converts a text string that represents a number to a number. 
VALUE ( Text )

VALUES

When a column name is given, returns a single-column table of unique values. When a table name is given, returns a table with the same columns and all the rows of the table (including duplicates) with the additional blank row caused by an invalid relationship if present. 
VALUES ( TableNameOrColumnName )

VAR

DAX statement keyword used to shape queries and calculations.

VAR.P

Calculates variance based on the entire population. Ignores logical values and text in the population. 
VAR.P ( ColumnName )

VAR.S

Estimates variance based on a sample. Ignores logical values and text in the sample. 
VAR.S ( ColumnName )

Variant

DAX data type used by expressions and model metadata.

VARX.P

Estimates variance based on the entire population that results from evaluating an expression for each row of a table. 
VARX.P ( Table, Expression )

VARX.S

Estimates variance based on a sample that results from evaluating an expression for each row of a table. 
VARX.S ( Table, Expression )

VDB

Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. VDB stands for variable declining balance. 
VDB ( Cost, Salvage, Life, Start_period, End_period, [Factor], [No_switch] )

Vega

Visualization grammar for defining interactive data graphics in JavaScript Object Notation.

Vega-Lite

Concise visualization grammar that compiles to Vega specifications.

VertiPaq

In-memory columnar engine that stores and queries tabular models.

VPAX

VPAX file extension; VertiPaq Analyzer package of model statistics.

W

WEEKDAY

Returns a number identifying the day of the week of a date. The number is in a range 1-7 or 0-6 according to the choice of the ReturnType parameter. 
WEEKDAY ( Date, [ReturnType] )

WEEKNUM

Returns the week number in the year. 
WEEKNUM ( Date, [ReturnType] )

WhatIf parameter

Power BI parameter that lets users adjust a value interactively.

WINDOW

Retrieves a range of rows within the specified partition, sorted by the specified order or on the axis specified. 
WINDOW ( From, [FromType], To, [ToType], [Relation], [OrderBy], [Blanks], [PartitionBy], [MatchBy], [Reset] )

Workspace mode

Tabular Editor workflow that syncs local metadata to a workspace database.

X

XIRR

Returns the internal rate of return for a schedule of cash flows that isn't necessarily periodic. 
XIRR ( Table, Values, Dates, [Guess], [AlternateResult] )

XMLA

eXtensible Markup Language for Analysis; protocol for querying and managing semantic models.

XMLA endpoint

eXtensible Markup Language for Analysis endpoint; surface for querying and managing semantic models.

XNPV

Returns the net present value for a schedule of cash flows. 
XNPV ( Table, Values, Dates, Rate )

Y

YEAR

Returns the year of a date as a four digit integer. 
YEAR ( Date )

YEARFRAC

Returns the year fraction representing the number of whole days between start_date and end_date. 
YEARFRAC ( StartDate, EndDate, [Basis] )

YIELD

Returns the yield on a security that pays periodic interest. Use YIELD to calculate bond yield. 
YIELD ( Settlement, Maturity, Rate, Pr, Redemption, Frequency, [Basis] )

YIELDDISC

Returns the annual yield for a discounted security. 
YIELDDISC ( Settlement, Maturity, Pr, Redemption, [Basis] )

YIELDMAT

Returns the annual yield of a security that pays interest at maturity. 
YIELDMAT ( Settlement, Maturity, Issue, Rate, Pr, [Basis] )