TypeFewer LettersMore Letters
Acronym #binary [Power Query M: Creates a binary value from numbers or text.](https://docs.microsoft.com/en-us/powerquery-m/sharpbinary)
Acronym #date [Power Query M: Creates a date value from year, month, and day.](https://docs.microsoft.com/en-us/powerquery-m/sharpdate)
Acronym #datetime [Power Query M: Creates a datetime value from year, month, day, hour, minute, and second.](https://docs.microsoft.com/en-us/powerquery-m/sharpdatetime)
Acronym #datetimezone [Power Query M: Creates a datetimezone value from year, month, day, hour, minute, second, offset-hours, and offset-minutes.](https://docs.microsoft.com/en-us/powerquery-m/sharpdatetimezone)
Acronym #duration [Power Query M: Creates a duration value from days, hour, minute, and second.](https://docs.microsoft.com/en-us/powerquery-m/sharpduration)
Acronym #time [Power Query M: Creates a time value from hour, minute, and second.](https://docs.microsoft.com/en-us/powerquery-m/sharptime)
Acronym ABS [Returns the absolute value of a number](https://support.microsoft.com/en-us/office/abs-function-3420200f-5628-4e8c-99da-c99d7c87713c)
Acronym Access.Database [Power Query M: Returns a structural representation of an Microsoft Access database.](https://docs.microsoft.com/en-us/powerquery-m/access-database)
Acronym AccessControlEntry.ConditionToId [Power Query M: Returns a list of identities that the condition will accept.](https://docs.microsoft.com/en-us/powerquery-m/accesscontrolentry-conditiontoidentities)
Acronym AccessControlKind.Allow [Power Query M: Access is allowed.](https://docs.microsoft.com/en-us/powerquery-m/accesscontrolkind-allow)
Acronym AccessControlKind.Deny [Power Query M: Access is denied.](https://docs.microsoft.com/en-us/powerquery-m/accesscontrolkind-deny)
Acronym ACCRINT [Returns the accrued interest for a security that pays periodic interest](https://support.microsoft.com/en-us/office/accrint-function-fe45d089-6722-4fb3-9379-e1f911d8dc74)
Acronym ACCRINTM [Returns the accrued interest for a security that pays interest at maturity](https://support.microsoft.com/en-us/office/accrintm-function-f62f01f9-5754-4cc4-805b-0e70199328a7)
Acronym ACOS [Returns the arccosine of a number](https://support.microsoft.com/en-us/office/acos-function-cb73173f-d089-4582-afa1-76e5524b5d5b)
Acronym ACOSH [Returns the inverse hyperbolic cosine of a number](https://support.microsoft.com/en-us/office/acosh-function-e3992cc1-103f-4e72-9f04-624b9ef5ebfe)
Acronym ACOT [Returns the arccotangent of a number](https://support.microsoft.com/en-us/office/acot-function-dc7e5008-fe6b-402e-bdd6-2eea8383d905)
Acronym ACOTH [Returns the hyperbolic arccotangent of a number](https://support.microsoft.com/en-us/office/acoth-function-cc49480f-f684-4171-9fc5-73e4e852300f)
Acronym ActiveDirectory.Domains [Power Query M: Returns a list of Active Directory domains in the same forest as the specified domain or of the current machine's domain if none is specified.](https://docs.microsoft.com/en-us/powerquery-m/activedirectory-domains)
Acronym ADDRESS [Returns a reference as text to a single cell in a worksheet](https://support.microsoft.com/en-us/office/address-function-d0c26c0d-3991-446b-8de4-ab46431d4f89)
Acronym AdobeAnalytics.Cubes [Power Query M: Returns the report suites in Adobe Analytics.](https://docs.microsoft.com/en-us/powerquery-m/adobeanalytics-cubes)
Acronym AdoDotNet.DataSource [Power Query M: Returns the schema collection for an ADO.NET data source.](https://docs.microsoft.com/en-us/powerquery-m/adodotnet-datasource)
Acronym AdoDotNet.Query [Power Query M: Returns the schema collection for an ADO.NET data source.](https://docs.microsoft.com/en-us/powerquery-m/adodotnet-query)
Acronym AGGREGATE [Returns an aggregate in a list or database](https://support.microsoft.com/en-us/office/aggregate-function-43b9278e-6aa7-4f17-92b6-e19993fa26df)
Acronym AMORDEGRC [Returns the depreciation for each accounting period by using a depreciation coefficient](https://support.microsoft.com/en-us/office/amordegrc-function-a14d0ca1-64a4-42eb-9b3d-b0dededf9e51)
Acronym AMORLINC [Returns the depreciation for each accounting period](https://support.microsoft.com/en-us/office/amorlinc-function-7d417b45-f7f5-4dba-a0a5-3451a81079a8)
Acronym AnalysisServices.Database [Power Query M: Returns a table of multidimensional cubes or tabular models from the Analysis Services database.](https://docs.microsoft.com/en-us/powerquery-m/analysisservices-database)
Acronym AnalysisServices.Databases [Power Query M: Returns the Analysis Services databases on a particular host.](https://docs.microsoft.com/en-us/powerquery-m/analysisservices-databases)
Acronym AND [Returns TRUE if all of its arguments are TRUE](https://support.microsoft.com/en-us/office/and-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9)
Acronym ARABIC [Converts a Roman number to Arabic, as a number](https://support.microsoft.com/en-us/office/arabic-function-9a8da418-c17b-4ef9-a657-9370a30a674f)
Acronym AREAS [Returns the number of areas in a reference](https://support.microsoft.com/en-us/office/areas-function-8392ba32-7a41-43b3-96b0-3695d2ec6152)
Acronym ARRAY [Array formulas are powerful formulas that enable you to perform complex calculations that often can't be done with standard worksheet functions. They are also referred to as "Ctrl-Shift-Enter" or "CSE" formulas, because you need to press Ctrl+Shift+Enter to enter them.](https://support.office.com/en-gb/article/Create-an-array-formula-e43e12e0-afc6-4a12-bc7f-48361075954d)
Acronym ARRAYFORMULA [Array formulas are powerful formulas that enable you to perform complex calculations that often can't be done with standard worksheet functions. They are also referred to as "Ctrl-Shift-Enter" or "CSE" formulas, because you need to press Ctrl+Shift+Enter to enter them.](https://support.office.com/en-gb/article/Create-an-array-formula-e43e12e0-afc6-4a12-bc7f-48361075954d)
Acronym ASC [Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters](https://support.microsoft.com/en-us/office/asc-function-0b6abf1c-c663-4004-a964-ebc00b723266)
Acronym ASIN [Returns the arcsine of a number](https://support.microsoft.com/en-us/office/asin-function-81fb95e5-6d6f-48c4-bc45-58f955c6d347)
Acronym ASINH [Returns the inverse hyperbolic sine of a number](https://support.microsoft.com/en-us/office/asinh-function-4e00475a-067a-43cf-926a-765b0249717c)
Acronym ATAN [Returns the arctangent of a number](https://support.microsoft.com/en-us/office/atan-function-50746fa8-630a-406b-81d0-4a2aed395543)
Acronym ATAN2 [Returns the arctangent from x- and y-coordinates](https://support.microsoft.com/en-us/office/atan2-function-c04592ab-b9e3-4908-b428-c96b3a565033)
Acronym ATANH [Returns the inverse hyperbolic tangent of a number](https://support.microsoft.com/en-us/office/atanh-function-3cd65768-0de7-4f1d-b312-d01c8c930d90)
Acronym AVEDEV [Returns the average of the absolute deviations of data points from their mean](https://support.microsoft.com/en-us/office/avedev-function-58fe8d65-2a84-4dc7-8052-f3f87b5c6639)
Acronym AVERAGE [Returns the average of its arguments](https://support.microsoft.com/en-us/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6)
Acronym AVERAGEA [Returns the average of its arguments, including numbers, text, and logical values](https://support.microsoft.com/en-us/office/averagea-function-f5f84098-d453-4f4c-bbba-3d2c66356091)
Acronym AVERAGEIF [Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria](https://support.microsoft.com/en-us/office/averageif-function-faec8e2e-0dec-4308-af69-f5576d8ac642)
Acronym AVERAGEIFS [Returns the average (arithmetic mean) of all cells that meet multiple criteria.](https://support.microsoft.com/en-us/office/averageifs-function-48910c45-1fc0-4389-a028-f7c5c3001690)
Acronym AVOID_BROKEN [See here for Microsoft guidance on to avoid broken formulas.](https://support.office.com/en-us/article/How-to-avoid-broken-formulas-8309381d-33e8-42f6-b889-84ef6df1d586)
Acronym AzureStorage.BlobContents [Power Query M: Returns the content of the specified blob from an Azure storage vault.](https://docs.microsoft.com/en-us/powerquery-m/azurestorage-blobcontents)
Acronym AzureStorage.Blobs [Power Query M: Returns a navigational table containing all containers found in the Azure Storage account. Each row has the container name and a link to the container blobs.](https://docs.microsoft.com/en-us/powerquery-m/azurestorage-blobs)
Acronym AzureStorage.DataLake [Power Query M: Returns a navigational table containing the documents found in the specified container and its subfolders from Azure Data Lake Storage.](https://docs.microsoft.com/en-us/powerquery-m/azurestorage-datalake)
Acronym AzureStorage.DataLakeContents [Power Query M: Returns the content of the specified file from an Azure Data Lake Storage filesystem.](https://docs.microsoft.com/en-us/powerquery-m/azurestorage-datalakecontents)
Acronym AzureStorage.Tables [Power Query M: Returns a navigational table containing a row for each table found at the account URL from an Azure storage vault. Each row contains a link to the azure table.](https://docs.microsoft.com/en-us/powerquery-m/azurestorage-tables)
Acronym BAHTTEXT [Converts a number to text, using the (baht) currency format](https://support.microsoft.com/en-us/office/bahttext-function-5ba4d0b4-abd3-4325-8d22-7a92d59aab9c)
Acronym BASE [Converts a number into a text representation with the given radix (base)](https://support.microsoft.com/en-us/office/base-function-2ef61411-aee9-4f29-a811-1c42456c6342)
Acronym BESSELI [Returns the modified Bessel function In(x)](https://support.microsoft.com/en-us/office/besseli-function-8d33855c-9a8d-444b-98e0-852267b1c0df)
Acronym BESSELJ [Returns the Bessel function Jn(x)](https://support.microsoft.com/en-us/office/besselj-function-839cb181-48de-408b-9d80-bd02982d94f7)
Acronym BESSELK [Returns the modified Bessel function Kn(x)](https://support.microsoft.com/en-us/office/besselk-function-606d11bc-06d3-4d53-9ecb-2803e2b90b70)
Acronym BESSELY [Returns the Bessel function Yn(x)](https://support.microsoft.com/en-us/office/bessely-function-f3a356b3-da89-42c3-8974-2da54d6353a2)
Acronym BETA.DIST [Returns the beta cumulative distribution function](https://support.microsoft.com/en-us/office/beta-dist-function-11188c9c-780a-42c7-ba43-9ecb5a878d31)
Acronym BETA.INV [Returns the inverse of the cumulative distribution function for a specified beta distribution](https://support.microsoft.com/en-us/office/beta-inv-function-e84cb8aa-8df0-4cf6-9892-83a341d252eb)
Acronym BETADIST [Returns the beta cumulative distribution function](https://support.microsoft.com/en-us/office/betadist-function-49f1b9a9-a5da-470f-8077-5f1730b5fd47)
Acronym BETAINV [Returns the inverse of the cumulative distribution function for a specified beta distribution](https://support.microsoft.com/en-us/office/betainv-function-8b914ade-b902-43c1-ac9c-c05c54f10d6c)
Acronym BIN2DEC [Converts a binary number to decimal](https://support.microsoft.com/en-us/office/bin2dec-function-63905b57-b3a0-453d-99f4-647bb519cd6c)
Acronym BIN2HEX [Converts a binary number to hexadecimal](https://support.microsoft.com/en-us/office/bin2hex-function-0375e507-f5e5-4077-9af8-28d84f9f41cc)
Acronym BIN2OCT [Converts a binary number to octal](https://support.microsoft.com/en-us/office/bin2oct-function-0a4e01ba-ac8d-4158-9b29-16c25c4c23fd)
Acronym Binary.Buffer [Power Query M: Buffers the binary value in memory. The result of this call is a stable binary value, which means it will have a deterministic length and order of bytes.](https://docs.microsoft.com/en-us/powerquery-m/binary-buffer)
Acronym Binary.Combine [Power Query M: Combines a list of binaries into a single binary.](https://docs.microsoft.com/en-us/powerquery-m/binary-combine)
Acronym Binary.Compress [Power Query M: Compresses a binary value using the given compression type.](https://docs.microsoft.com/en-us/powerquery-m/binary-compress)
Acronym Binary.Decompress [Power Query M: Decompresses a binary value using the given compression type.](https://docs.microsoft.com/en-us/powerquery-m/binary-decompress)
Acronym Binary.From [Power Query M: Returns a binary value from the given value.](https://docs.microsoft.com/en-us/powerquery-m/binary-from)
Acronym Binary.FromList [Power Query M: Converts a list of numbers into a binary value](https://docs.microsoft.com/en-us/powerquery-m/binary-fromlist)
Acronym Binary.FromText [Power Query M: Decodes data from a text form into binary.](https://docs.microsoft.com/en-us/powerquery-m/binary-fromtext)
Acronym Binary.InferContentType [Power Query M: Returns a record with field Content.Type that contains the inferred MIME-type.](https://docs.microsoft.com/en-us/powerquery-m/binary-infercontenttype)
Acronym Binary.Length [Power Query M: Returns the length of binary values.](https://docs.microsoft.com/en-us/powerquery-m/binary-length)
Acronym Binary.ToList [Power Query M: Converts a binary value into a list of numbers](https://docs.microsoft.com/en-us/powerquery-m/binary-tolist)
Acronym Binary.ToText [Power Query M: Encodes binary data into a text form.](https://docs.microsoft.com/en-us/powerquery-m/binary-totext)
Acronym BinaryEncoding.Base64 [Power Query M: Constant to use as the encoding type when base-64 encoding is required.](https://docs.microsoft.com/en-us/powerquery-m/binaryencoding-base64)
Acronym BinaryEncoding.Hex [Power Query M: Constant to use as the encoding type when hexadecimal encoding is required.](https://docs.microsoft.com/en-us/powerquery-m/binaryencoding-hex)
Acronym BinaryFormat.7BitEncodedSignedIn [Power Query M: A binary format that reads a 64-bit signed integer that was encoded using a 7-bit variable-length encoding.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-7bitencodedsignedinteger)
Acronym BinaryFormat.7BitEncodedUnsigned [Power Query M: A binary format that reads a 64-bit unsigned integer that was encoded using a 7-bit variable-length encoding.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-7bitencodedunsignedinteger)
Acronym BinaryFormat.Binary [Power Query M: Returns a binary format that reads a binary value.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-binary)
Acronym BinaryFormat.Byte [Power Query M: A binary format that reads an 8-bit unsigned integer.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-byte)
Acronym BinaryFormat.ByteOrder [Power Query M: Returns a binary format with the byte order specified by a function.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-byteorder)
Acronym BinaryFormat.Choice [Power Query M: Returns a binary format that chooses the next binary format based on a value that has already been read.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-choice)
Acronym BinaryFormat.Decimal [Power Query M: A binary format that reads a .NET 16-byte decimal value.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-decimal)
Acronym BinaryFormat.Double [Power Query M: A binary format that reads an 8-byte IEEE double-precision floating point value.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-double)
Acronym BinaryFormat.Group [Power Query M: Returns a binary format that reads a group of items. Each item value is preceded by a unique key value. The result is a list of item values.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-group)
Acronym BinaryFormat.Length [Power Query M: Returns a binary format that limits the amount of data that can be read. Both BinaryFormat.List and BinaryFormat.Binary can be used to read until end of the data. BinaryFormat.Length can be used to limit the number of bytes that are read.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-length)
Acronym BinaryFormat.List [Power Query M: Returns a binary format that reads a sequence of items and returns a list.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-list)
Acronym BinaryFormat.Null [Power Query M: A binary format that reads zero bytes and returns null.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-null)
Acronym BinaryFormat.Record [Power Query M: Returns a binary format that reads a record. Each field in the record can have a different binary format.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-record)
Acronym BinaryFormat.SignedInteger16 [Power Query M: A binary format that reads a 16-bit signed integer.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-signedinteger16)
Acronym BinaryFormat.SignedInteger32 [Power Query M: A binary format that reads a 32-bit signed integer.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-signedinteger32)
Acronym BinaryFormat.SignedInteger64 [Power Query M: A binary format that reads a 64-bit signed integer.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-signedinteger64)
Acronym BinaryFormat.Single [Power Query M: A binary format that reads a 4-byte IEEE single-precision floating point value.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-single)
Acronym BinaryFormat.Text [Power Query M: Returns a binary format that reads a text value. The optional encoding value specifies the encoding of the text.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-text)
Acronym BinaryFormat.Transform [Power Query M: Returns a binary format that will transform the values read by another binary format.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-transform)
Acronym BinaryFormat.UnsignedInteger16 [Power Query M: A binary format that reads a 16-bit unsigned integer.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-unsignedinteger16)
Acronym BinaryFormat.UnsignedInteger32 [Power Query M: A binary format that reads a 32-bit unsigned integer.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-unsignedinteger32)
Acronym BinaryFormat.UnsignedInteger64 [Power Query M: A binary format that reads a 64-bit unsigned integer.](https://docs.microsoft.com/en-us/powerquery-m/binaryformat-unsignedinteger64)
Acronym BinaryOccurrence.Optional [Power Query M: The item is expected to appear zero or one time in the input.](https://docs.microsoft.com/en-us/powerquery-m/binaryoccurrence-optional)
Acronym BinaryOccurrence.Repeating [Power Query M: The item is expected to appear zero or more times in the input.](https://docs.microsoft.com/en-us/powerquery-m/binaryoccurrence-repeating)
Acronym BinaryOccurrence.Required [Power Query M: The item is expected to appear once in the input.](https://docs.microsoft.com/en-us/powerquery-m/binaryoccurrence-required)
Acronym BINOM.DIST [Returns the individual term binomial distribution probability](https://support.microsoft.com/en-us/office/binom-dist-function-c5ae37b6-f39c-4be2-94c2-509a1480770c)
Acronym BINOM.DIST.RANGE [Returns the probability of a trial result using a binomial distribution](https://support.microsoft.com/en-us/office/binom-dist-range-function-17331329-74c7-4053-bb4c-6653a7421595)
Acronym BINOM.INV [Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value](https://support.microsoft.com/en-us/office/binom-inv-function-80a0370c-ada6-49b4-83e7-05a91ba77ac9)
Acronym BINOMDIST [Returns the individual term binomial distribution probability](https://support.microsoft.com/en-us/office/binomdist-function-506a663e-c4ca-428d-b9a8-05583d68789c)
Acronym BITAND [Returns a 'Bitwise And' of two numbers](https://support.microsoft.com/en-us/office/bitand-function-8a2be3d7-91c3-4b48-9517-64548008563a)
Acronym BITLSHIFT [Returns a value number shifted left by shift_amount bits](https://support.microsoft.com/en-us/office/bitlshift-function-c55bb27e-cacd-4c7c-b258-d80861a03c9c)
Acronym BITOR [Returns a bitwise OR of 2 numbers](https://support.microsoft.com/en-us/office/bitor-function-f6ead5c8-5b98-4c9e-9053-8ad5234919b2)
Acronym BITRSHIFT [Returns a value number shifted right by shift_amount bits](https://support.microsoft.com/en-us/office/bitrshift-function-274d6996-f42c-4743-abdb-4ff95351222c)
Acronym BITXOR [Returns a bitwise 'Exclusive Or' of two numbers](https://support.microsoft.com/en-us/office/bitxor-function-c81306a1-03f9-4e89-85ac-b86c3cba10e4)
Acronym Byte.From [Power Query M: Returns a 8-bit integer number value from the given value.](https://docs.microsoft.com/en-us/powerquery-m/byte-from)
Acronym ByteOrder.BigEndian [Power Query M: A possible value for the byteOrder parameter in BinaryFormat.ByteOrder. The most signficant byte appears first in Big Endian byte order.](https://docs.microsoft.com/en-us/powerquery-m/byteorder-bigendian)
Acronym ByteOrder.LittleEndian [Power Query M: A possible value for the byteOrder parameter in BinaryFormat.ByteOrder. The least signficant byte appears first in Little Endian byte order.](https://docs.microsoft.com/en-us/powerquery-m/byteorder-littleendian)
Acronym CALL [Calls a procedure in a dynamic link library or code resource](https://support.microsoft.com/en-us/office/call-function-32d58445-e646-4ffd-8d5e-b45077a5e995)
Acronym Cdm.Contents [Power Query M: This function is unavailable because it requires .NET 4.5.](https://docs.microsoft.com/en-us/powerquery-m/cdm-contents)
Acronym Cdpa.Database [Power Query M: Provides access to a CDPA database.](https://docs.microsoft.com/en-us/powerquery-m/cdpa-database)
Acronym CEILING [Rounds a number to the nearest integer or to the nearest multiple of significance](https://support.microsoft.com/en-us/office/ceiling-function-0a5cd7c8-0720-4f0a-bd2c-c943e510899f)
Acronym CEILING.MATH [Rounds a number up, to the nearest integer or to the nearest multiple of significance](https://support.microsoft.com/en-us/office/ceiling-math-function-80f95d2f-b499-4eee-9f16-f795a8e306c8)
Acronym CEILING.PRECISE [Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.](https://support.microsoft.com/en-us/office/ceiling-precise-function-f366a774-527a-4c92-ba49-af0a196e66cb)
Acronym CELL [Returns information about the formatting, location, or contents of a cell](https://support.microsoft.com/en-us/office/cell-function-51bd39a5-f338-4dbe-a33f-955d67c2b2cf)
Acronym CHAR [Returns the character specified by the code number](https://support.microsoft.com/en-us/office/char-function-bbd249c8-b36e-4a91-8017-1c133f9b837a)
Acronym Character.FromNumber [Power Query M: Returns a number to its character value.](https://docs.microsoft.com/en-us/powerquery-m/character-fromnumber)
Acronym Character.ToNumber [Power Query M: Returns a character to its number value.](https://docs.microsoft.com/en-us/powerquery-m/character-tonumber)
Acronym CHIDIST [Returns the one-tailed probability of the chi-squared distribution](https://support.microsoft.com/en-us/office/chidist-function-c90d0fbc-5b56-4f5f-ab57-34af1bf6897e)
Acronym CHIINV [Returns the inverse of the one-tailed probability of the chi-squared distribution](https://support.microsoft.com/en-us/office/chiinv-function-cfbea3f6-6e4f-40c9-a87f-20472e0512af)
Acronym CHISQ.DIST [Returns the cumulative beta probability density function](https://support.microsoft.com/en-us/office/chisq-dist-function-8486b05e-5c05-4942-a9ea-f6b341518732)
Acronym CHISQ.DIST.RT [Returns the one-tailed probability of the chi-squared distribution](https://support.microsoft.com/en-us/office/chisq-dist-rt-function-dc4832e8-ed2b-49ae-8d7c-b28d5804c0f2)
Acronym CHISQ.INV [Returns the cumulative beta probability density function](https://support.microsoft.com/en-us/office/chisq-inv-function-400db556-62b3-472d-80b3-254723e7092f)
Acronym CHISQ.INV.RT [Returns the inverse of the one-tailed probability of the chi-squared distribution](https://support.microsoft.com/en-us/office/chisq-inv-rt-function-435b5ed8-98d5-4da6-823f-293e2cbc94fe)
Acronym CHISQ.TEST [Returns the test for independence](https://support.microsoft.com/en-us/office/chisq-test-function-2e8a7861-b14a-4985-aa93-fb88de3f260f)
Acronym CHITEST [Returns the test for independence](https://support.microsoft.com/en-us/office/chitest-function-981ff871-b694-4134-848e-38ec704577ac)
Acronym CHOOSE [Chooses a value from a list of values](https://support.microsoft.com/en-us/office/choose-function-fc5c184f-cb62-4ec7-a46e-38653b98f5bc)
Acronym CLEAN [Removes all nonprintable characters from text](https://support.microsoft.com/en-us/office/clean-function-26f3d7c5-475f-4a9c-90e5-4b8ba987ba41)
Acronym CODE [Returns a numeric code for the first character in a text string](https://support.microsoft.com/en-us/office/code-function-c32b692b-2ed0-4a04-bdd9-75640144b928)
Acronym COLUMN [Returns the column number of a reference](https://support.microsoft.com/en-us/office/column-function-44e8c754-711c-4df3-9da4-47a55042554b)
Acronym COLUMNS [Returns the number of columns in a reference](https://support.microsoft.com/en-us/office/columns-function-4e8e7b4e-e603-43e8-b177-956088fa48ca)
Acronym COMBIN [Returns the number of combinations for a given number of objects](https://support.microsoft.com/en-us/office/combin-function-12a3f276-0a21-423a-8de6-06990aaf638a)
Acronym COMBINA [Returns the number of combinations with repetitions for a given number of items](https://support.microsoft.com/en-us/office/combina-function-efb49eaa-4f4c-4cd2-8179-0ddfcf9d035d)
Acronym Combiner.CombineTextByDelimiter [Power Query M: Returns a function that combines a list of text into a single text using the specified delimiter.](https://docs.microsoft.com/en-us/powerquery-m/combiner-combinetextbydelimiter)
Acronym Combiner.CombineTextByEachDelimi [Power Query M: Returns a function that combines a list of text into a single text using each specified delimiter in sequence.](https://docs.microsoft.com/en-us/powerquery-m/combiner-combinetextbyeachdelimiter)
Acronym Combiner.CombineTextByLengths [Power Query M: Returns a function that combines a list of text into a single text using the specified lengths.](https://docs.microsoft.com/en-us/powerquery-m/combiner-combinetextbylengths)
Acronym Combiner.CombineTextByPositions [Power Query M: Returns a function that combines a list of text into a single text using the specified positions.](https://docs.microsoft.com/en-us/powerquery-m/combiner-combinetextbypositions)
Acronym Combiner.CombineTextByRanges [Power Query M: Returns a function that combines a list of text into a single text using the specified positions and lengths.](https://docs.microsoft.com/en-us/powerquery-m/combiner-combinetextbyranges)
Acronym Comparer.Equals [Power Query M: Returns a logical value based on the equality check over the two given values.](https://docs.microsoft.com/en-us/powerquery-m/comparer-equals)
Acronym Comparer.FromCulture [Power Query M: Returns a comparer function given the culture and a logical value for case sensitivity for the comparison. The default value for ignoreCase is false. The value for culture are well known text representations of locales used in the .NET framework.](https://docs.microsoft.com/en-us/powerquery-m/comparer-fromculture)
Acronym Comparer.Ordinal [Power Query M: Returns a comparer function which uses Ordinal rules to compare values.](https://docs.microsoft.com/en-us/powerquery-m/comparer-ordinal)
Acronym Comparer.OrdinalIgnoreCase [Power Query M: Returns a case-insensitive comparer function which uses Ordinal rules to compare the provided values x and y.](https://docs.microsoft.com/en-us/powerquery-m/comparer-ordinalignorecase)
Acronym COMPLEX [Converts real and imaginary coefficients into a complex number](https://support.microsoft.com/en-us/office/complex-function-f0b8f3a9-51cc-4d6d-86fb-3a9362fa4128)
Acronym Compression.Brotli [Power Query M: The compressed data is in the 'Brotli' format.](https://docs.microsoft.com/en-us/powerquery-m/compression-brotli)
Acronym Compression.Deflate [Power Query M: The compressed data is in the 'Deflate' format.](https://docs.microsoft.com/en-us/powerquery-m/compression-deflate)
Acronym Compression.GZip [Power Query M: The compressed data is in the 'GZip' format.](https://docs.microsoft.com/en-us/powerquery-m/compression-gzip)
Acronym Compression.LZ4 [Power Query M: The compressed data is in the 'LZ4' format.](https://docs.microsoft.com/en-us/powerquery-m/compression-lz4)
Acronym Compression.None [Power Query M: The data is uncompressed.](https://docs.microsoft.com/en-us/powerquery-m/compression-none)
Acronym Compression.Snappy [Power Query M: The compressed data is in the 'Snappy' format.](https://docs.microsoft.com/en-us/powerquery-m/compression-snappy)
Acronym Compression.Zstandard [Power Query M: The compressed data is in the 'Zstandard' format.](https://docs.microsoft.com/en-us/powerquery-m/compression-zstandard)
Acronym CONCAT [Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.](https://support.microsoft.com/en-us/office/concat-function-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2)
Acronym CONCATENATE [Joins several text items into one text item](https://support.microsoft.com/en-us/office/concatenate-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d)
Acronym CONFIDENCE [Returns the confidence interval for a population mean](https://support.microsoft.com/en-us/office/confidence-function-75ccc007-f77c-4343-bc14-673642091ad6)
Acronym CONFIDENCE.NORM [Returns the confidence interval for a population mean](https://support.microsoft.com/en-us/office/confidence-norm-function-7cec58a6-85bb-488d-91c3-63828d4fbfd4)
Acronym CONFIDENCE.T [Returns the confidence interval for a population mean, using a Student's t distribution](https://support.microsoft.com/en-us/office/confidence-t-function-e8eca395-6c3a-4ba9-9003-79ccc61d3c53)
Acronym CONVERT [Converts a number from one measurement system to another](https://support.microsoft.com/en-us/office/convert-function-d785bef1-808e-4aac-bdcd-666c810f9af2)
Acronym CORREL [Returns the correlation coefficient between two data sets](https://support.microsoft.com/en-us/office/correl-function-995dcef7-0c0a-4bed-a3fb-239d7b68ca92)
Acronym COS [Returns the cosine of a number](https://support.microsoft.com/en-us/office/cos-function-0fb808a5-95d6-4553-8148-22aebdce5f05)
Acronym COSH [Returns the hyperbolic cosine of a number](https://support.microsoft.com/en-us/office/cosh-function-e460d426-c471-43e8-9540-a57ff3b70555)
Acronym COT [Returns the hyperbolic cosine of a number](https://support.microsoft.com/en-us/office/cot-function-c446f34d-6fe4-40dc-84f8-cf59e5f5e31a)
Acronym COTH [Returns the cotangent of an angle](https://support.microsoft.com/en-us/office/coth-function-2e0b4cb6-0ba0-403e-aed4-deaa71b49df5)
Acronym COUNT [Counts how many numbers are in the list of arguments](https://support.microsoft.com/en-us/office/count-function-a59cd7fc-b623-4d93-87a4-d23bf411294c)
Acronym COUNTA [Counts how many values are in the list of arguments](https://support.microsoft.com/en-us/office/counta-function-7dc98875-d5c1-46f1-9a82-53f3219e2509)
Acronym COUNTBLANK [Counts the number of blank cells within a range](https://support.microsoft.com/en-us/office/countblank-function-6a92d772-675c-4bee-b346-24af6bd3ac22)
Acronym COUNTIF [Counts the number of cells within a range that meet the given criteria](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34)
Acronym COUNTIFS [Counts the number of cells within a range that meet multiple criteria](https://support.microsoft.com/en-us/office/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842)
Acronym COUPDAYBS [Returns the number of days from the beginning of the coupon period to the settlement date](https://support.microsoft.com/en-us/office/coupdaybs-function-eb9a8dfb-2fb2-4c61-8e5d-690b320cf872)
Acronym COUPDAYS [Returns the number of days in the coupon period that contains the settlement date](https://support.microsoft.com/en-us/office/coupdays-function-cc64380b-315b-4e7b-950c-b30b0a76f671)
Acronym COUPDAYSNC [Returns the number of days from the settlement date to the next coupon date](https://support.microsoft.com/en-us/office/coupdaysnc-function-5ab3f0b2-029f-4a8b-bb65-47d525eea547)
Acronym COUPNCD [Returns the next coupon date after the settlement date](https://support.microsoft.com/en-us/office/coupncd-function-fd962fef-506b-4d9d-8590-16df5393691f)
Acronym COUPNUM [Returns the number of coupons payable between the settlement date and maturity date](https://support.microsoft.com/en-us/office/coupnum-function-a90af57b-de53-4969-9c99-dd6139db2522)
Acronym COUPPCD [Returns the previous coupon date before the settlement date](https://support.microsoft.com/en-us/office/couppcd-function-2eb50473-6ee9-4052-a206-77a9a385d5b3)
Acronym COVAR [Returns covariance, the average of the products of paired deviations](https://support.microsoft.com/en-us/office/covar-function-50479552-2c03-4daf-bd71-a5ab88b2db03)
Acronym COVARIANCE.P [Returns covariance, the average of the products of paired deviations](https://support.microsoft.com/en-us/office/covariance-p-function-6f0e1e6d-956d-4e4b-9943-cfef0bf9edfc)
Acronym COVARIANCE.S [Returns the sample covariance, the average of the products deviations for each data point pair in two data sets](https://support.microsoft.com/en-us/office/covariance-s-function-0a539b74-7371-42aa-a18f-1f5320314977)
Acronym CRITBINOM [Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value](https://support.microsoft.com/en-us/office/critbinom-function-eb6b871d-796b-4d21-b69b-e4350d5f407b)
Acronym CSC [Returns the cosecant of an angle](https://support.microsoft.com/en-us/office/csc-function-07379361-219a-4398-8675-07ddc4f135c1)
Acronym CSCH [Returns the hyperbolic cosecant of an angle](https://support.microsoft.com/en-us/office/csch-function-f58f2c22-eb75-4dd6-84f4-a503527f8eeb)
Acronym CSE [Array formulas are powerful formulas that enable you to perform complex calculations that often can't be done with standard worksheet functions. They are also referred to as "Ctrl-Shift-Enter" or "CSE" formulas, because you need to press Ctrl+Shift+Enter to enter them.](https://support.office.com/en-gb/article/Create-an-array-formula-e43e12e0-afc6-4a12-bc7f-48361075954d)
Acronym Csv.Document [Power Query M: Returns the contents of a CSV document as a table using the specified encoding.](https://docs.microsoft.com/en-us/powerquery-m/csv-document)
Acronym CsvStyle.QuoteAfterDelimiter [Power Query M: Quotes in a field are only significant immediately following the delimiter.](https://docs.microsoft.com/en-us/powerquery-m/csvstyle-quoteafterdelimiter)
Acronym CsvStyle.QuoteAlways [Power Query M: Quotes in a field are always significant regardless of where they appear.](https://docs.microsoft.com/en-us/powerquery-m/csvstyle-quotealways)
Acronym Cube.AddAndExpandDimensionColumn [Power Query M: Merges the specified dimension table, dimensionSelector, into the cubes, cube, filter context and changes the dimensional granularity by expanding the specified set, attributeNames, of dimension attributes.](https://docs.microsoft.com/en-us/powerquery-m/cube-addandexpanddimensioncolumn)
Acronym Cube.AddMeasureColumn [Power Query M: Adds a column with the name column to the cube that contains the results of the measure measureSelector applied in the row context of each row.](https://docs.microsoft.com/en-us/powerquery-m/cube-addmeasurecolumn)
Acronym Cube.ApplyParameter [Power Query M: Returns a cube after applying parameter with arguments to cube.](https://docs.microsoft.com/en-us/powerquery-m/cube-applyparameter)
Acronym Cube.AttributeMemberId [Power Query M: Returns the unique member identifier from a member property value.](https://docs.microsoft.com/en-us/powerquery-m/cube-attributememberid)
Acronym Cube.AttributeMemberProperty [Power Query M: Returns the property propertyName of dimension attribute attribute.](https://docs.microsoft.com/en-us/powerquery-m/cube-attributememberproperty)
Acronym Cube.CollapseAndRemoveColumns [Power Query M: Changes the dimensional granularity of the filter context for the cube by collapsing the attributes mapped to the specified columns columnNames.](https://docs.microsoft.com/en-us/powerquery-m/cube-collapseandremovecolumns)
Acronym Cube.Dimensions [Power Query M: Returns a table containing the set of available dimensions within the cube.](https://docs.microsoft.com/en-us/powerquery-m/cube-dimensions)
Acronym Cube.DisplayFolders [Power Query M: Returns a nested tree of tables representing the display folder hierarchy of the objects (e.g. dimensions and measures) available for use in the cube.](https://docs.microsoft.com/en-us/powerquery-m/cube-displayfolders)
Acronym Cube.MeasureProperties [Power Query M: Returns a table containing the set of available properties for measures that are expanded in the cube.](https://docs.microsoft.com/en-us/powerquery-m/cube-measureproperties)
Acronym Cube.MeasureProperty [Power Query M: Returns the property of a measure.](https://docs.microsoft.com/en-us/powerquery-m/cube-measureproperty)
Acronym Cube.Measures [Power Query M: Returns a table containing the set of available measures within the cube.](https://docs.microsoft.com/en-us/powerquery-m/cube-measures)
Acronym Cube.Parameters [Power Query M: Returns a table containing the set of parameters that can be applied to cube.](https://docs.microsoft.com/en-us/powerquery-m/cube-parameters)
Acronym Cube.Properties [Power Query M: Returns a table containing the set of available properties for dimensions that are expanded in the cube.](https://docs.microsoft.com/en-us/powerquery-m/cube-properties)
Acronym Cube.PropertyKey [Power Query M: Returns the key of property property.](https://docs.microsoft.com/en-us/powerquery-m/cube-propertykey)
Acronym Cube.ReplaceDimensions [Power Query M: No Description Provided. Click here to go to the documentation page.](https://docs.microsoft.com/en-us/powerquery-m/cube-replacedimensions)
Acronym Cube.Transform [Power Query M: Applies the list cube functions, transforms, on the cube.](https://docs.microsoft.com/en-us/powerquery-m/cube-transform)
Acronym CUBEKPIMEMBER [Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance.](https://support.microsoft.com/en-us/office/cubekpimember-function-744608bf-2c62-42cd-b67a-a56109f4b03b)
Acronym CUBEMEMBER [Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.](https://support.microsoft.com/en-us/office/cubemember-function-0f6a15b9-2c18-4819-ae89-e1b5c8b398ad)
Acronym CUBEMEMBERPROPERTY [Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member.](https://support.microsoft.com/en-us/office/cubememberproperty-function-001e57d6-b35a-49e5-abcd-05ff599e8951)
Acronym CUBERANKEDMEMBER [Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students.](https://support.microsoft.com/en-us/office/cuberankedmember-function-07efecde-e669-4075-b4bf-6b40df2dc4b3)
Acronym CUBESET [Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel.](https://support.microsoft.com/en-us/office/cubeset-function-5b2146bd-62d6-4d04-9d8f-670e993ee1d9)
Acronym CUBESETCOUNT [Returns the number of items in a set.](https://support.microsoft.com/en-us/office/cubesetcount-function-c4c2a438-c1ff-4061-80fe-982f2d705286)
Acronym CUBEVALUE [Returns an aggregated value from a cube.](https://support.microsoft.com/en-us/office/cubevalue-function-8733da24-26d1-4e34-9b3a-84a8f00dcbe0)
Acronym Culture.Current [Power Query M: Returns the current culture of the system.](https://docs.microsoft.com/en-us/powerquery-m/culture-current)
Acronym CUMIPMT [Returns the cumulative interest paid between two periods](https://support.microsoft.com/en-us/office/cumipmt-function-61067bb0-9016-427d-b95b-1a752af0e606)
Acronym CUMPRINC [Returns the cumulative principal paid on a loan between two periods](https://support.microsoft.com/en-us/office/cumprinc-function-94a4516d-bd65-41a1-bc16-053a6af4c04d)
Acronym Currency.From [Power Query M: Returns a currency value from the given value.](https://docs.microsoft.com/en-us/powerquery-m/currency-from)
Acronym DATE [Returns the serial number of a particular date](https://support.microsoft.com/en-us/office/date-function-e36c0c8c-4104-49da-ab83-82328b832349)
Acronym Date.AddDays [Power Query M: Returns a Date/DateTime/DateTimeZone value with the day portion incremented by the number of days provided. It also handles incrementing the month and year potions of the value as appropriate.](https://docs.microsoft.com/en-us/powerquery-m/date-adddays)
Acronym Date.AddMonths [Power Query M: Returns a DateTime value with the month portion incremented by n months.](https://docs.microsoft.com/en-us/powerquery-m/date-addmonths)
Acronym Date.AddQuarters [Power Query M: Returns a Date/DateTime/DateTimeZone value incremented by the number of quarters provided. Each quarter is defined as a duration of three months. It also handles incrementing the year potion of the value as appropriate.](https://docs.microsoft.com/en-us/powerquery-m/date-addquarters)
Acronym Date.AddWeeks [Power Query M: Returns a Date/DateTime/DateTimeZone value incremented by the number of weeks provided. Each week is defined as a duration of seven days. It also handles incrementing the month and year potions of the value as appropriate.](https://docs.microsoft.com/en-us/powerquery-m/date-addweeks)
Acronym Date.AddYears [Power Query M: Returns a DateTime value with the year portion incremented by n years.](https://docs.microsoft.com/en-us/powerquery-m/date-addyears)
Acronym Date.Day [Power Query M: Returns the day for a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/date-day)
Acronym Date.DayOfWeek [Power Query M: Returns a number (from 0 to 6) indicating the day of the week of the provided value.](https://docs.microsoft.com/en-us/powerquery-m/date-dayofweek)
Acronym Date.DayOfWeekName [Power Query M: Returns the day of the week name.](https://docs.microsoft.com/en-us/powerquery-m/date-dayofweekname)
Acronym Date.DayOfYear [Power Query M: Returns a number that represents the day of the year from a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/date-dayofyear)
Acronym Date.DaysInMonth [Power Query M: Returns the number of days in the month from a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/date-daysinmonth)
Acronym Date.EndOfDay [Power Query M: Returns a DateTime value for the end of the day.](https://docs.microsoft.com/en-us/powerquery-m/date-endofday)
Acronym Date.EndOfMonth [Power Query M: Returns a DateTime value for the end of the month.](https://docs.microsoft.com/en-us/powerquery-m/date-endofmonth)
Acronym Date.EndOfQuarter [Power Query M: Returns a Date/DateTime/DateTimeZone value representing the end of the quarter. The date and time portions are reset to their terminating values for the quarter. The timezone information is persisted.](https://docs.microsoft.com/en-us/powerquery-m/date-endofquarter)
Acronym Date.EndOfWeek [Power Query M: Returns a DateTime value for the end of the week.](https://docs.microsoft.com/en-us/powerquery-m/date-endofweek)
Acronym Date.EndOfYear [Power Query M: Returns a DateTime value for the end of the year.](https://docs.microsoft.com/en-us/powerquery-m/date-endofyear)
Acronym Date.From [Power Query M: Returns a date value from a value.](https://docs.microsoft.com/en-us/powerquery-m/date-from)
Acronym Date.FromText [Power Query M: Returns a Date value from a set of date formats and culture value.](https://docs.microsoft.com/en-us/powerquery-m/date-fromtext)
Acronym Date.IsInCurrentDay [Power Query M: Indicates whether the given datetime value dateTime occurs during the current day, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isincurrentday)
Acronym Date.IsInCurrentMonth [Power Query M: Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the current month, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isincurrentmonth)
Acronym Date.IsInCurrentQuarter [Power Query M: Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the current quarter, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isincurrentquarter)
Acronym Date.IsInCurrentWeek [Power Query M: Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the current week, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isincurrentweek)
Acronym Date.IsInCurrentYear [Power Query M: Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the current year, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isincurrentyear)
Acronym Date.IsInNextDay [Power Query M: Indicates whether the given datetime value dateTime occurs during the next day, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinnextday)
Acronym Date.IsInNextMonth [Power Query M: Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next month, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinnextmonth)
Acronym Date.IsInNextNDays [Power Query M: Indicates whether the given datetime value dateTime occurs during the next number of days, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinnextndays)
Acronym Date.IsInNextNMonths [Power Query M: Indicates whether the given datetime value dateTime occurs during the next number of months, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinnextnmonths)
Acronym Date.IsInNextNQuarters [Power Query M: Indicates whether the given datetime value dateTime occurs during the next number of quarters, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinnextnquarters)
Acronym Date.IsInNextNWeeks [Power Query M: Indicates whether the given datetime value dateTime occurs during the next number of weeks, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinnextnweeks)
Acronym Date.IsInNextNYears [Power Query M: Indicates whether the given datetime value dateTime occurs during the next number of years, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinnextnyears)
Acronym Date.IsInNextQuarter [Power Query M: Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next quarter, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinnextquarter)
Acronym Date.IsInNextWeek [Power Query M: Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next week, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinnextweek)
Acronym Date.IsInNextYear [Power Query M: Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next year, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinnextyear)
Acronym Date.IsInPreviousDay [Power Query M: Indicates whether the given datetime value dateTime occurs during the previous day, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinpreviousday)
Acronym Date.IsInPreviousMonth [Power Query M: Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous month, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinpreviousmonth)
Acronym Date.IsInPreviousNDays [Power Query M: Indicates whether the given datetime value dateTime occurs during the previous number of days, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinpreviousndays)
Acronym Date.IsInPreviousNMonths [Power Query M: Indicates whether the given datetime value dateTime occurs during the previous number of months, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinpreviousnmonths)
Acronym Date.IsInPreviousNQuarters [Power Query M: Indicates whether the given datetime value dateTime occurs during the previous number of quarters, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinpreviousnquarters)
Acronym Date.IsInPreviousNWeeks [Power Query M: Indicates whether the given datetime value dateTime occurs during the previous number of weeks, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinpreviousnweeks)
Acronym Date.IsInPreviousNYears [Power Query M: Indicates whether the given datetime value dateTime occurs during the previous number of years, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinpreviousnyears)
Acronym Date.IsInPreviousQuarter [Power Query M: Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous quarter, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinpreviousquarter)
Acronym Date.IsInPreviousWeek [Power Query M: Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous week, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinpreviousweek)
Acronym Date.IsInPreviousYear [Power Query M: Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous year, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinpreviousyear)
Acronym Date.IsInYearToDate [Power Query M: Returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred in the period starting January 1st of the current year and ending on the current day, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/date-isinyeartodate)
Acronym Date.IsLeapYear [Power Query M: Returns a logical value indicating whether the year portion of a DateTime value is a leap year.](https://docs.microsoft.com/en-us/powerquery-m/date-isleapyear)
Acronym Date.Month [Power Query M: Returns the month from a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/date-month)
Acronym Date.MonthName [Power Query M: Returns the name of the month component.](https://docs.microsoft.com/en-us/powerquery-m/date-monthname)
Acronym Date.QuarterOfYear [Power Query M: Returns a number between 1 and 4 for the quarter of the year from a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/date-quarterofyear)
Acronym Date.StartOfDay [Power Query M: Returns a DateTime value for the start of the day.](https://docs.microsoft.com/en-us/powerquery-m/date-startofday)
Acronym Date.StartOfMonth [Power Query M: Returns a DateTime value representing the start of the month.](https://docs.microsoft.com/en-us/powerquery-m/date-startofmonth)
Acronym Date.StartOfQuarter [Power Query M: Returns a DateTime value representing the start of the quarter.](https://docs.microsoft.com/en-us/powerquery-m/date-startofquarter)
Acronym Date.StartOfWeek [Power Query M: Returns a DateTime value representing the start of the week.](https://docs.microsoft.com/en-us/powerquery-m/date-startofweek)
Acronym Date.StartOfYear [Power Query M: Returns a DateTime value representing the start of the year.](https://docs.microsoft.com/en-us/powerquery-m/date-startofyear)
Acronym Date.ToRecord [Power Query M: Returns a record containing parts of a Date value.](https://docs.microsoft.com/en-us/powerquery-m/date-torecord)
Acronym Date.ToText [Power Query M: Returns a text value from a Date value.](https://docs.microsoft.com/en-us/powerquery-m/date-totext)
Acronym Date.WeekOfMonth [Power Query M: Returns a number for the count of week in the current month.](https://docs.microsoft.com/en-us/powerquery-m/date-weekofmonth)
Acronym Date.WeekOfYear [Power Query M: Returns a number for the count of week in the current year.](https://docs.microsoft.com/en-us/powerquery-m/date-weekofyear)
Acronym Date.Year [Power Query M: Returns the year from a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/date-year)
Acronym DATEDIF [Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.](https://support.microsoft.com/en-us/office/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c)
Acronym DateTime.AddZone [Power Query M: Adds the timezonehours as an offset to the input datetime value and returns a new datetimezone value.](https://docs.microsoft.com/en-us/powerquery-m/datetime-addzone)
Acronym DateTime.Date [Power Query M: Returns a date part from a DateTime value](https://docs.microsoft.com/en-us/powerquery-m/datetime-date)
Acronym DateTime.FixedLocalNow [Power Query M: Returns a DateTime value set to the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-fixedlocalnow)
Acronym DateTime.From [Power Query M: Returns a datetime value from a value.](https://docs.microsoft.com/en-us/powerquery-m/datetime-from)
Acronym DateTime.FromFileTime [Power Query M: Returns a DateTime value from the supplied number.](https://docs.microsoft.com/en-us/powerquery-m/datetime-fromfiletime)
Acronym DateTime.FromText [Power Query M: Returns a DateTime value from a set of date formats and culture value.](https://docs.microsoft.com/en-us/powerquery-m/datetime-fromtext)
Acronym DateTime.IsInCurrentHour [Power Query M: Indicates whether the given datetime value occurs during the current hour, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isincurrenthour)
Acronym DateTime.IsInCurrentMinute [Power Query M: Indicates whether the given datetime value occurs during the current minute, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isincurrentminute)
Acronym DateTime.IsInCurrentSecond [Power Query M: Indicates whether the given datetime value occurs during the current second, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isincurrentsecond)
Acronym DateTime.IsInNextHour [Power Query M: Indicates whether the given datetime value occurs during the next hour, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isinnexthour)
Acronym DateTime.IsInNextMinute [Power Query M: Indicates whether the given datetime value occurs during the next minute, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isinnextminute)
Acronym DateTime.IsInNextNHours [Power Query M: Indicates whether the given datetime value occurs during the next number of hours, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isinnextnhours)
Acronym DateTime.IsInNextNMinutes [Power Query M: Indicates whether the given datetime value occurs during the next number of minutes, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isinnextnminutes)
Acronym DateTime.IsInNextNSeconds [Power Query M: Indicates whether the given datetime value occurs during the next number of seconds, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isinnextnseconds)
Acronym DateTime.IsInNextSecond [Power Query M: Indicates whether the given datetime value occurs during the next second, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isinnextsecond)
Acronym DateTime.IsInPreviousHour [Power Query M: Indicates whether the given datetime value occurs during the previous hour, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isinprevioushour)
Acronym DateTime.IsInPreviousMinute [Power Query M: Indicates whether the given datetime value occurs during the previous minute, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isinpreviousminute)
Acronym DateTime.IsInPreviousNHours [Power Query M: Indicates whether the given datetime value occurs during the previous number of hours, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isinpreviousnhours)
Acronym DateTime.IsInPreviousNMinutes [Power Query M: Indicates whether the given datetime value occurs during the previous number of minutes, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isinpreviousnminutes)
Acronym DateTime.IsInPreviousNSeconds [Power Query M: Indicates whether the given datetime value occurs during the previous number of seconds, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isinpreviousnseconds)
Acronym DateTime.IsInPreviousSecond [Power Query M: Indicates whether the given datetime value occurs during the previous second, as determined by the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-isinprevioussecond)
Acronym DateTime.LocalNow [Power Query M: Returns a datetime value set to the current date and time on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetime-localnow)
Acronym DateTime.Time [Power Query M: Returns a time part from a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/datetime-time)
Acronym DateTime.ToRecord [Power Query M: Returns a record containing parts of a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/datetime-torecord)
Acronym DateTime.ToText [Power Query M: Returns a text value from a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/datetime-totext)
Acronym DateTimeZone.FixedLocalNow [Power Query M: Returns a DateTimeZone value set to the current date, time, and timezone offset on the system.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-fixedlocalnow)
Acronym DateTimeZone.FixedUtcNow [Power Query M: Returns the current date and time in UTC (the GMT timezone).](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-fixedutcnow)
Acronym DateTimeZone.From [Power Query M: Returns a datetimezone value from a value.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-from)
Acronym DateTimeZone.FromFileTime [Power Query M: Returns a DateTimeZone from a number value.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-fromfiletime)
Acronym DateTimeZone.FromText [Power Query M: Returns a DateTimeZone value from a set of date formats and culture value.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-fromtext)
Acronym DateTimeZone.LocalNow [Power Query M: Returns a DateTime value set to the current system date and time.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-localnow)
Acronym DateTimeZone.RemoveZone [Power Query M: Returns a datetime value with the zone information removed from the input datetimezone value.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-removezone)
Acronym DateTimeZone.SwitchZone [Power Query M: Changes the timezone information for the input DateTimeZone.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-switchzone)
Acronym DateTimeZone.ToLocal [Power Query M: Returns a DateTime value from the local time zone.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-tolocal)
Acronym DateTimeZone.ToRecord [Power Query M: Returns a record containing parts of a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-torecord)
Acronym DateTimeZone.ToText [Power Query M: Returns a text value from a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-totext)
Acronym DateTimeZone.ToUtc [Power Query M: Returns a DateTime value to the Utc time zone.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-toutc)
Acronym DateTimeZone.UtcNow [Power Query M: Returns a DateTime value set to the current system date and time in the Utc timezone.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-utcnow)
Acronym DateTimeZone.ZoneHours [Power Query M: Returns a time zone hour value from a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-zonehours)
Acronym DateTimeZone.ZoneMinutes [Power Query M: Returns a time zone minute value from a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/datetimezone-zoneminutes)
Acronym DATEVALUE [Converts a date in the form of text to a serial number](https://support.microsoft.com/en-us/office/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252)
Acronym DAVERAGE [Returns the average of selected database entries](https://support.microsoft.com/en-us/office/daverage-function-a6a2d5ac-4b4b-48cd-a1d8-7b37834e5aee)
Acronym DAY [Converts a serial number to a day of the month](https://support.microsoft.com/en-us/office/day-function-8a7d1cbb-6c7d-4ba1-8aea-25c134d03101)
Acronym Day.Friday [Power Query M: Represents Friday.](https://docs.microsoft.com/en-us/powerquery-m/day-friday)
Acronym Day.Monday [Power Query M: Represents Monday.](https://docs.microsoft.com/en-us/powerquery-m/day-monday)
Acronym Day.Saturday [Power Query M: Represents Saturday.](https://docs.microsoft.com/en-us/powerquery-m/day-saturday)
Acronym Day.Sunday [Power Query M: Represents Sunday.](https://docs.microsoft.com/en-us/powerquery-m/day-sunday)
Acronym Day.Thursday [Power Query M: Represents Thursday.](https://docs.microsoft.com/en-us/powerquery-m/day-thursday)
Acronym Day.Tuesday [Power Query M: Represents Tuesday.](https://docs.microsoft.com/en-us/powerquery-m/day-tuesday)
Acronym Day.Wednesday [Power Query M: Represents Wednesday.](https://docs.microsoft.com/en-us/powerquery-m/day-wednesday)
Acronym DAYS [Returns the number of days between two dates](https://support.microsoft.com/en-us/office/days-function-57740535-d549-4395-8728-0f07bff0b9df)
Acronym DAYS360 [Calculates the number of days between two dates based on a 360-day year](https://support.microsoft.com/en-us/office/days360-function-b9a509fd-49ef-407e-94df-0cbda5718c2a)
Acronym DB [Returns the depreciation of an asset for a specified period by using the fixed-declining balance method](https://support.microsoft.com/en-us/office/db-function-354e7d28-5f93-4ff1-8a52-eb4ee549d9d7)
Acronym DB2.Database [Power Query M: Returns a table of SQL tables and views available in a Db2 database.](https://docs.microsoft.com/en-us/powerquery-m/db2-database)
Acronym DBCS [Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters](https://support.microsoft.com/en-us/office/dbcs-function-a4025e73-63d2-4958-9423-21a24794c9e5)
Acronym DCOUNT [Counts the cells that contain numbers in a database](https://support.microsoft.com/en-us/office/dcount-function-c1fc7b93-fb0d-4d8d-97db-8d5f076eaeb1)
Acronym DCOUNTA [Counts nonblank cells in a database](https://support.microsoft.com/en-us/office/dcounta-function-00232a6d-5a66-4a01-a25b-c1653fda1244)
Acronym DDB [Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify](https://support.microsoft.com/en-us/office/ddb-function-519a7a37-8772-4c96-85c0-ed2c209717a5)
Acronym DEC2BIN [Converts a decimal number to binary](https://support.microsoft.com/en-us/office/dec2bin-function-0f63dd0e-5d1a-42d8-b511-5bf5c6d43838)
Acronym DEC2HEX [Converts a decimal number to hexadecimal](https://support.microsoft.com/en-us/office/dec2hex-function-6344ee8b-b6b5-4c6a-a672-f64666704619)
Acronym DEC2OCT [Converts a decimal number to octal](https://support.microsoft.com/en-us/office/dec2oct-function-c9d835ca-20b7-40c4-8a9e-d3be351ce00f)
Acronym DECIMAL [Converts a text representation of a number in a given base into a decimal number](https://support.microsoft.com/en-us/office/decimal-function-ee554665-6176-46ef-82de-0a283658da2e)
Acronym Decimal.From [Power Query M: Returns a decimal number value from the given value.](https://docs.microsoft.com/en-us/powerquery-m/decimal-from)
Acronym DEGREES [Converts radians to degrees](https://support.microsoft.com/en-us/office/degrees-function-4d6ec4db-e694-4b94-ace0-1cc3f61f9ba1)
Acronym DELTA [Tests whether two values are equal](https://support.microsoft.com/en-us/office/delta-function-2f763672-c959-4e07-ac33-fe03220ba432)
Acronym DEVSQ [Returns the sum of squares of deviations](https://support.microsoft.com/en-us/office/devsq-function-8b739616-8376-4df5-8bd0-cfe0a6caf444)
Acronym DGET [Extracts from a database a single record that matches the specified criteria](https://support.microsoft.com/en-us/office/dget-function-455568bf-4eef-45f7-90f0-ec250d00892e)
Acronym Diagnostics.ActivityId [Power Query M: Returns an opaque identifier for the currently-running evaluation.](https://docs.microsoft.com/en-us/powerquery-m/diagnostics-activityid)
Acronym Diagnostics.Trace [Power Query M: Writes a trace message, if tracing is enabled, and returns value.](https://docs.microsoft.com/en-us/powerquery-m/diagnostics-trace)
Acronym DirectQueryCapabilities.From [Power Query M: DirectQueryCapabilities.From](https://docs.microsoft.com/en-us/powerquery-m/directquerycapabilities-from)
Acronym DISC [Returns the discount rate for a security](https://support.microsoft.com/en-us/office/disc-function-71fce9f3-3f05-4acf-a5a3-eac6ef4daa53)
Acronym DMAX [Returns the maximum value from selected database entries](https://support.microsoft.com/en-us/office/dmax-function-f4e8209d-8958-4c3d-a1ee-6351665d41c2)
Acronym DMIN [Returns the minimum value from selected database entries](https://support.microsoft.com/en-us/office/dmin-function-4ae6f1d9-1f26-40f1-a783-6dc3680192a3)
Acronym DOLLAR [Converts a number to text, using the $ (dollar) currency format](https://support.microsoft.com/en-us/office/dollar-function-a6cd05d9-9740-4ad3-a469-8109d18ff611)
Acronym DOLLARDE [Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number](https://support.microsoft.com/en-us/office/dollarde-function-db85aab0-1677-428a-9dfd-a38476693427)
Acronym DOLLARFR [Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction](https://support.microsoft.com/en-us/office/dollarfr-function-0835d163-3023-4a33-9824-3042c5d4f495)
Acronym Double.From [Power Query M: Returns a Double number value from the given value.](https://docs.microsoft.com/en-us/powerquery-m/double-from)
Acronym DPRODUCT [Multiplies the values in a particular field of records that match the criteria in a database](https://support.microsoft.com/en-us/office/dproduct-function-4f96b13e-d49c-47a7-b769-22f6d017cb31)
Acronym DSTDEV [Estimates the standard deviation based on a sample of selected database entries](https://support.microsoft.com/en-us/office/dstdev-function-026b8c73-616d-4b5e-b072-241871c4ab96)
Acronym DSTDEVP [Calculates the standard deviation based on the entire population of selected database entries](https://support.microsoft.com/en-us/office/dstdevp-function-04b78995-da03-4813-bbd9-d74fd0f5d94b)
Acronym DSUM [Adds the numbers in the field column of records in the database that match the criteria](https://support.microsoft.com/en-us/office/dsum-function-53181285-0c4b-4f5a-aaa3-529a322be41b)
Acronym DURATION [Returns the annual duration of a security with periodic interest payments](https://support.microsoft.com/en-us/office/duration-function-b254ea57-eadc-4602-a86a-c8e369334038)
Acronym Duration.Days [Power Query M: Returns the day component of a Duration value.](https://docs.microsoft.com/en-us/powerquery-m/duration-days)
Acronym Duration.From [Power Query M: Returns a duration value from a value.](https://docs.microsoft.com/en-us/powerquery-m/duration-from)
Acronym Duration.FromText [Power Query M: Returns a Duration value from a text value.](https://docs.microsoft.com/en-us/powerquery-m/duration-fromtext)
Acronym Duration.Hours [Power Query M: Returns an hour component of a Duration value.](https://docs.microsoft.com/en-us/powerquery-m/duration-hours)
Acronym Duration.Minutes [Power Query M: Returns a minute component of a Duration value.](https://docs.microsoft.com/en-us/powerquery-m/duration-minutes)
Acronym Duration.Seconds [Power Query M: Returns a second component of a Duration value.](https://docs.microsoft.com/en-us/powerquery-m/duration-seconds)
Acronym Duration.ToRecord [Power Query M: Returns a record with parts of a Duration value.](https://docs.microsoft.com/en-us/powerquery-m/duration-torecord)
Acronym Duration.TotalDays [Power Query M: Returns the total magnitude of days from a Duration value.](https://docs.microsoft.com/en-us/powerquery-m/duration-totaldays)
Acronym Duration.TotalHours [Power Query M: Returns the total magnitude of hours from a Duration value.](https://docs.microsoft.com/en-us/powerquery-m/duration-totalhours)
Acronym Duration.TotalMinutes [Power Query M: Returns the total magnitude of minutes from a Duration value.](https://docs.microsoft.com/en-us/powerquery-m/duration-totalminutes)
Acronym Duration.TotalSeconds [Power Query M: Returns the total magnitude of seconds from a duration value.](https://docs.microsoft.com/en-us/powerquery-m/duration-totalseconds)
Acronym Duration.ToText [Power Query M: Returns a text value from a Duration value.](https://docs.microsoft.com/en-us/powerquery-m/duration-totext)
Acronym DVAR [Estimates variance based on a sample from selected database entries](https://support.microsoft.com/en-us/office/dvar-function-d6747ca9-99c7-48bb-996e-9d7af00f3ed1)
Acronym DVARP [Calculates variance based on the entire population of selected database entries](https://support.microsoft.com/en-us/office/dvarp-function-eb0ba387-9cb7-45c8-81e9-0394912502fc)
Acronym EDATE [Returns the serial number of the date that is the indicated number of months before or after the start date](https://support.microsoft.com/en-us/office/edate-function-3c920eb2-6e66-44e7-a1f5-753ae47ee4f5)
Acronym EFFECT [Returns the effective annual interest rate](https://support.microsoft.com/en-us/office/effect-function-910d4e4c-79e2-4009-95e6-507e04f11bc4)
Acronym Embedded.Value [Power Query M: Accesses a value by name in an embedded mashup.](https://docs.microsoft.com/en-us/powerquery-m/embedded-value)
Acronym ENCODEURL [Returns a URL-encoded string](https://support.microsoft.com/en-us/office/encodeurl-function-07c7fb90-7c60-4bff-8687-fac50fe33d0e)
Acronym EOMONTH [Returns the serial number of the last day of the month before or after a specified number of months](https://support.microsoft.com/en-us/office/eomonth-function-7314ffa1-2bc9-4005-9d66-f49db127d628)
Acronym ERF [Returns the error function](https://support.microsoft.com/en-us/office/erf-function-c53c7e7b-5482-4b6c-883e-56df3c9af349)
Acronym ERF.PRECISE [Returns the error function](https://support.microsoft.com/en-us/office/erf-precise-function-9a349593-705c-4278-9a98-e4122831a8e0)
Acronym ERFC [Returns the complementary error function](https://support.microsoft.com/en-us/office/erfc-function-736e0318-70ba-4e8b-8d08-461fe68b71b3)
Acronym ERFC.PRECISE [Returns the complementary ERF function integrated between x and infinity](https://support.microsoft.com/en-us/office/erfc-precise-function-e90e6bab-f45e-45df-b2ac-cd2eb4d4a273)
Acronym Error.Record [Power Query M: Returns a record containing fields Reason, Message, and Detail set to the provided values. The record can be used to raise or throw an error.](https://docs.microsoft.com/en-us/powerquery-m/error-record)
Acronym ERROR.TYPE [Returns a number corresponding to an error type](https://support.microsoft.com/en-us/office/error-type-function-10958677-7c8d-44f7-ae77-b9a9ee6eefaa)
Acronym ERROR_CHECKING [Formulas can sometimes result in error values in addition to returning unintended results. Click here for some tools that you can use to find and investigate the causes of these errors and determine solutions.](https://support.office.com/en-us/article/Use-error-checking-to-detect-errors-in-formulas-4d4c160b-8d9a-45f1-bec7-75f4b90045f8)
Acronym Essbase.Cubes [Power Query M: Returns the cubes in an Essbase instance grouped by Essbase server.](https://docs.microsoft.com/en-us/powerquery-m/essbase-cubes)
Acronym EUROCONVERT [Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation).](https://support.microsoft.com/en-us/office/euroconvert-function-79c8fd67-c665-450c-bb6c-15fc92f8345c)
Acronym EVEN [Rounds a number up to the nearest even integer](https://support.microsoft.com/en-us/office/even-function-197b5f06-c795-4c1e-8696-3c3b8a646cf9)
Acronym EXACT [Checks to see if two text values are identical](https://support.microsoft.com/en-us/office/exact-function-d3087698-fc15-4a15-9631-12575cf29926)
Acronym Excel.CurrentWorkbook [Power Query M: Returns the tables in the current Excel Workbook.](https://docs.microsoft.com/en-us/powerquery-m/excel-currentworkbook)
Acronym Excel.Workbook [Power Query M: Returns a table representing sheets in the given excel workbook.](https://docs.microsoft.com/en-us/powerquery-m/excel-workbook)
Acronym Exchange.Contents [Power Query M: Returns a table of contents from a Microsoft Exchange account.](https://docs.microsoft.com/en-us/powerquery-m/exchange-contents)
Acronym EXP [Returns e raised to the power of a given number](https://support.microsoft.com/en-us/office/exp-function-c578f034-2c45-4c37-bc8c-329660a63abe)
Acronym EXPON.DIST [Returns the exponential distribution](https://support.microsoft.com/en-us/office/expon-dist-function-4c12ae24-e563-4155-bf3e-8b78b6ae140e)
Acronym EXPONDIST [Returns the exponential distribution](https://support.microsoft.com/en-us/office/expondist-function-68ab45fd-cd6d-4887-9770-9357eb8ee06a)
Acronym Expression.Constant [Power Query M: Returns the M source code representation of a constant value.](https://docs.microsoft.com/en-us/powerquery-m/expression-constant)
Acronym Expression.Evaluate [Power Query M: Returns the result of evaluating an M expression.](https://docs.microsoft.com/en-us/powerquery-m/expression-evaluate)
Acronym Expression.Identifier [Power Query M: Returns the M source code representation of an identifier.](https://docs.microsoft.com/en-us/powerquery-m/expression-identifier)
Acronym ExtraValues.Error [Power Query M: If the splitter function returns more columns than the table expects, an error should be raised.](https://docs.microsoft.com/en-us/powerquery-m/extravalues-error)
Acronym ExtraValues.Ignore [Power Query M: If the splitter function returns more columns than the table expects, they should be ignored.](https://docs.microsoft.com/en-us/powerquery-m/extravalues-ignore)
Acronym ExtraValues.List [Power Query M: If the splitter function returns more columns than the table expects, they should be collected into a list.](https://docs.microsoft.com/en-us/powerquery-m/extravalues-list)
Acronym F.DIST [Returns the F probability distribution](https://support.microsoft.com/en-us/office/f-dist-function-a887efdc-7c8e-46cb-a74a-f884cd29b25d)
Acronym F.DIST.RT [Returns the F probability distribution](https://support.microsoft.com/en-us/office/f-dist-rt-function-d74cbb00-6017-4ac9-b7d7-6049badc0520)
Acronym F.INV [Returns the inverse of the F probability distribution](https://support.microsoft.com/en-us/office/f-inv-function-0dda0cf9-4ea0-42fd-8c3c-417a1ff30dbe)
Acronym F.INV.RT [Returns the inverse of the F probability distribution](https://support.microsoft.com/en-us/office/f-inv-rt-function-d371aa8f-b0b1-40ef-9cc2-496f0693ac00)
Acronym F.TEST [Returns the result of an F-test](https://support.microsoft.com/en-us/office/f-test-function-100a59e7-4108-46f8-8443-78ffacb6c0a7)
Acronym FACT [Returns the factorial of a number](https://support.microsoft.com/en-us/office/fact-function-ca8588c2-15f2-41c0-8e8c-c11bd471a4f3)
Acronym FACTDOUBLE [Returns the double factorial of a number](https://support.microsoft.com/en-us/office/factdouble-function-e67697ac-d214-48eb-b7b7-cce2589ecac8)
Acronym FALSE [Returns the logical value FALSE](https://support.microsoft.com/en-us/office/false-function-2d58dfa5-9c03-4259-bf8f-f0ae14346904)
Acronym FDIST [Returns the F probability distribution](https://support.microsoft.com/en-us/office/fdist-function-ecf76fba-b3f1-4e7d-a57e-6a5b7460b786)
Acronym File.Contents [Power Query M: Returns the binary contents of the file located at a path.](https://docs.microsoft.com/en-us/powerquery-m/file-contents)
Acronym FILTER [Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)
Acronym FILTERXML [Returns specific data from the XML content by using the specified XPath](https://support.microsoft.com/en-us/office/filterxml-function-4df72efc-11ec-4951-86f5-c1374812f5b7)
Acronym FIND [Finds one text value within another (case-sensitive)](https://support.microsoft.com/en-us/office/find-findb-functions-c7912941-af2a-4bdf-a553-d0d89b0a0628)
Acronym FINDB [Finds one text value within another (case-sensitive)](https://support.microsoft.com/en-us/office/find-findb-functions-c7912941-af2a-4bdf-a553-d0d89b0a0628)
Acronym FINV [Returns the inverse of the F probability distribution](https://support.microsoft.com/en-us/office/finv-function-4d46c97c-c368-4852-bc15-41e8e31140b1)
Acronym FISHER [Returns the Fisher transformation](https://support.microsoft.com/en-us/office/fisher-function-d656523c-5076-4f95-b87b-7741bf236c69)
Acronym FISHERINV [Returns the inverse of the Fisher transformation](https://support.microsoft.com/en-us/office/fisherinv-function-62504b39-415a-4284-a285-19c8e82f86bb)
Acronym FIXED [Formats a number as text with a fixed number of decimals](https://support.microsoft.com/en-us/office/fixed-function-ffd5723c-324c-45e9-8b96-e41be2a8274a)
Acronym FLOOR [Rounds a number down, toward zero](https://support.microsoft.com/en-us/office/floor-function-14bb497c-24f2-4e04-b327-b0b4de5a8886)
Acronym FLOOR.MATH [Rounds a number down, to the nearest integer or to the nearest multiple of significance](https://support.microsoft.com/en-us/office/floor-math-function-c302b599-fbdb-4177-ba19-2c2b1249a2f5)
Acronym FLOOR.PRECISE [Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.](https://support.microsoft.com/en-us/office/floor-precise-function-f769b468-1452-4617-8dc3-02f842a0702e)
Acronym Folder.Contents [Power Query M: Returns a table containing the properties and contents of the files and folders found at path.](https://docs.microsoft.com/en-us/powerquery-m/folder-contents)
Acronym Folder.Files [Power Query M: Returns a table containing a row for each file found at a folder path, and subfolders. Each row contains properties of the folder or file and a link to its content.](https://docs.microsoft.com/en-us/powerquery-m/folder-files)
Acronym FORECAST [Returns a value along a linear trend](https://support.microsoft.com/en-us/office/forecast-and-forecast-linear-functions-50ca49c9-7b40-4892-94e4-7ad38bbeda99)
Acronym FORECAST.ETS [Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm](https://support.microsoft.com/en-us/office/forecasting-functions-reference-897a2fe9-6595-4680-a0b0-93e0308d5f6e#_forecast.ets)
Acronym FORECAST.ETS.CONFINT [Returns a confidence interval for the forecast value at the specified target date](https://support.microsoft.com/en-us/office/forecasting-functions-reference-897a2fe9-6595-4680-a0b0-93e0308d5f6e#_forecast.ets.confint)
Acronym FORECAST.ETS.SEASONALITY [Returns the length of the repetitive pattern Excel detects for the specified time series](https://support.microsoft.com/en-us/office/forecasting-functions-reference-897a2fe9-6595-4680-a0b0-93e0308d5f6e#_forecast.ets.seasonality)
Acronym FORECAST.ETS.STAT [Returns a statistical value as a result of time series forecasting](https://support.microsoft.com/en-us/office/forecasting-functions-reference-897a2fe9-6595-4680-a0b0-93e0308d5f6e#_forecast.ets.stat)
Acronym FORECAST.LINEAR [Returns a future value based on existing values](https://support.microsoft.com/en-us/office/forecasting-functions-reference-897a2fe9-6595-4680-a0b0-93e0308d5f6e#_forecast.linear)
Acronym FORECASTING [Here is a list of Excel forecasting functions. forecasting functions can be used to predict future values based on historical data. These functions use advanced machine learning algorithms, such as Exponential Triple Smoothing (ETS).](https://support.office.com/en-us/article/Forecasting-functions-897a2fe9-6595-4680-a0b0-93e0308d5f6e)
Acronym FORMULATEXT [Returns the formula at the given reference as text](https://support.microsoft.com/en-us/office/formulatext-function-0a786771-54fd-4ae2-96ee-09cda35439c8)
Acronym FORMULA_OVERVIEW [Click here for an overview of formulas in Excel. Get started on how to create formulas and use built-in functions to perform calculations and solve problems.](https://support.office.com/en-us/article/Overview-of-formulas-in-Excel-ecfdc708-9162-49e8-b993-c311f47ca173)
Acronym FREQUENCY [Returns a frequency distribution as a vertical array](https://support.microsoft.com/en-us/office/frequency-function-44e3be2b-eca0-42cd-a3f7-fd9ea898fdb9)
Acronym FTEST [Returns the result of an F-test](https://support.microsoft.com/en-us/office/ftest-function-4c9e1202-53fe-428c-a737-976f6fc3f9fd)
Acronym Function.From [Power Query M: Takes a unary function function and creates a new function with the type functionType that constructs a list out of its arguments and passes it to function.](https://docs.microsoft.com/en-us/powerquery-m/function-from)
Acronym Function.Invoke [Power Query M: Invokes the given function using the specified and returns the result.](https://docs.microsoft.com/en-us/powerquery-m/function-invoke)
Acronym Function.InvokeAfter [Power Query M: Returns the result of invoking function after duration delay has passed.](https://docs.microsoft.com/en-us/powerquery-m/function-invokeafter)
Acronym Function.IsDataSource [Power Query M: Returns whether or not function is considered a data source.](https://docs.microsoft.com/en-us/powerquery-m/function-isdatasource)
Acronym Function.ScalarVector [Power Query M: Returns a scalar function of type scalarFunctionType that invokes vectorFunction with a single row of arguments and returns its single output.](https://docs.microsoft.com/en-us/powerquery-m/function-scalarvector)
Acronym FUNCTION_LIST [Here is a list of Excel functions categorized by their functionality.](https://support.office.com/en-us/article/Excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb)
Acronym FV [Returns the future value of an investment](https://support.microsoft.com/en-us/office/fv-function-2eef9f44-a084-4c61-bdd8-4fe4bb1b71b3)
Acronym FVSCHEDULE [Returns the future value of an initial principal after applying a series of compound interest rates](https://support.microsoft.com/en-us/office/fvschedule-function-bec29522-bd87-4082-bab9-a241f3fb251d)
Acronym GAMMA [Returns the Gamma function value](https://support.microsoft.com/en-us/office/gamma-function-ce1702b1-cf55-471d-8307-f83be0fc5297)
Acronym GAMMA.DIST [Returns the gamma distribution](https://support.microsoft.com/en-us/office/gamma-dist-function-9b6f1538-d11c-4d5f-8966-21f6a2201def)
Acronym GAMMA.INV [Returns the inverse of the gamma cumulative distribution](https://support.microsoft.com/en-us/office/gamma-inv-function-74991443-c2b0-4be5-aaab-1aa4d71fbb18)
Acronym GAMMADIST [Returns the gamma distribution](https://support.microsoft.com/en-us/office/gammadist-function-7327c94d-0f05-4511-83df-1dd7ed23e19e)
Acronym GAMMAINV [Returns the inverse of the gamma cumulative distribution](https://support.microsoft.com/en-us/office/gammainv-function-06393558-37ab-47d0-aa63-432f99e7916d)
Acronym GAMMALN [Returns the natural logarithm of the gamma function, (x)](https://support.microsoft.com/en-us/office/gammaln-function-b838c48b-c65f-484f-9e1d-141c55470eb9)
Acronym GAMMALN.PRECISE [Returns the natural logarithm of the gamma function, (x)](https://support.microsoft.com/en-us/office/gammaln-precise-function-5cdfe601-4e1e-4189-9d74-241ef1caa599)
Acronym GAUSS [Returns 0.5 less than the standard normal cumulative distribution](https://support.microsoft.com/en-us/office/gauss-function-069f1b4e-7dee-4d6a-a71f-4b69044a6b33)
Acronym GCD [Returns the greatest common divisor](https://support.microsoft.com/en-us/office/gcd-function-d5107a51-69e3-461f-8e4c-ddfc21b5073a)
Acronym Geography.FromWellKnownText [Power Query M: Translates text representing a geographic value in Well-Known Text (WKT) format into a structured record.](https://docs.microsoft.com/en-us/powerquery-m/geography-fromwellknowntext)
Acronym Geography.ToWellKnownText [Power Query M: Translates a structured geographic point value into its Well-Known Text (WKT) representation.](https://docs.microsoft.com/en-us/powerquery-m/geography-towellknowntext)
Acronym GeographyPoint.From [Power Query M: Creates a record representing a geographic point from parts.](https://docs.microsoft.com/en-us/powerquery-m/geographypoint-from)
Acronym GEOMEAN [Returns the geometric mean](https://support.microsoft.com/en-us/office/geomean-function-db1ac48d-25a5-40a0-ab83-0b38980e40d5)
Acronym Geometry.FromWellKnownText [Power Query M: Translates text representing a geometric value in Well-Known Text (WKT) format into a structured record.](https://docs.microsoft.com/en-us/powerquery-m/geometry-fromwellknowntext)
Acronym Geometry.ToWellKnownText [Power Query M: Translates a structured geometric point value into its Well-Known Text (WKT) representation.](https://docs.microsoft.com/en-us/powerquery-m/geometry-towellknowntext)
Acronym GeometryPoint.From [Power Query M: Creates a record representing a geometric point from parts.](https://docs.microsoft.com/en-us/powerquery-m/geometrypoint-from)
Acronym GESTEP [Tests whether a number is greater than a threshold value](https://support.microsoft.com/en-us/office/gestep-function-f37e7d2a-41da-4129-be95-640883fca9df)
Acronym GETPIVOTDATA [Returns data stored in a PivotTable report](https://support.microsoft.com/en-us/office/getpivotdata-function-8c083b99-a922-4ca0-af5e-3af55960761f)
Acronym GoogleAnalytics.Accounts [Power Query M: Returns the Google Analytics accounts for the current credential.](https://docs.microsoft.com/en-us/powerquery-m/googleanalytics-accounts)
Acronym GroupKind.Global [Power Query M: GroupKind.Global](https://docs.microsoft.com/en-us/powerquery-m/groupkind-global)
Acronym GroupKind.Local [Power Query M: GroupKind.Local](https://docs.microsoft.com/en-us/powerquery-m/groupkind-local)
Acronym GROWTH [Returns values along an exponential trend](https://support.microsoft.com/en-us/office/growth-function-541a91dc-3d5e-437d-b156-21324e68b80d)
Acronym Guid.From [Power Query M: Returns a Guid.Type value from the given value.](https://docs.microsoft.com/en-us/powerquery-m/guid-from)
Acronym HARMEAN [Returns the harmonic mean](https://support.microsoft.com/en-us/office/harmean-function-5efd9184-fab5-42f9-b1d3-57883a1d3bc6)
Acronym Hdfs.Contents [Power Query M: Returns a table containing a row for each folder and file found at the folder url, {0}, from a Hadoop file system. Each row contains properties of the folder or file and a link to its content.](https://docs.microsoft.com/en-us/powerquery-m/hdfs-contents)
Acronym Hdfs.Files [Power Query M: Returns a table containing a row for each file found at the folder url, {0}, and subfolders from a Hadoop file system. Each row contains properties of the file and a link to its content.](https://docs.microsoft.com/en-us/powerquery-m/hdfs-files)
Acronym HdInsight.Containers [Power Query M: Returns a navigational table containing all containers found in the HDInsight account. Each row has the container name and table containing its files.](https://docs.microsoft.com/en-us/powerquery-m/hdinsight-containers)
Acronym HdInsight.Contents [Power Query M: Returns a navigational table containing all containers found in the HDInsight account. Each row has the container name and table containing its files.](https://docs.microsoft.com/en-us/powerquery-m/hdinsight-contents)
Acronym HdInsight.Files [Power Query M: Returns a table containing a row for each folder and file found at the container URL, and subfolders from an HDInsight account. Each row contains properties of the file/folder and a link to its content.](https://docs.microsoft.com/en-us/powerquery-m/hdinsight-files)
Acronym HEX2BIN [Converts a hexadecimal number to binary](https://support.microsoft.com/en-us/office/hex2bin-function-a13aafaa-5737-4920-8424-643e581828c1)
Acronym HEX2DEC [Converts a hexadecimal number to decimal](https://support.microsoft.com/en-us/office/hex2dec-function-8c8c3155-9f37-45a5-a3ee-ee5379ef106e)
Acronym HEX2OCT [Converts a hexadecimal number to octal](https://support.microsoft.com/en-us/office/hex2oct-function-54d52808-5d19-4bd0-8a63-1096a5d11912)
Acronym HLOOKUP [Looks in the top row of an array and returns the value of the indicated cell](https://support.microsoft.com/en-us/office/hlookup-function-a3034eec-b719-4ba3-bb65-e1ad662ed95f)
Acronym HOUR [Converts a serial number to an hour](https://support.microsoft.com/en-us/office/hour-function-a3afa879-86cb-4339-b1b5-2dd2d7310ac7)
Acronym Html.Table [Power Query M: Returns a table containing the results of running the specified CSS selectors against the provided html.](https://docs.microsoft.com/en-us/powerquery-m/html-table)
Acronym HYPERLINK [Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet](https://support.microsoft.com/en-us/office/hyperlink-function-333c7ce6-c5ae-4164-9c47-7de9b76f577f)
Acronym HYPGEOM.DIST [Returns the hypergeometric distribution](https://support.microsoft.com/en-us/office/hypgeom-dist-function-6dbd547f-1d12-4b1f-8ae5-b0d9e3d22fbf)
Acronym HYPGEOMDIST [Returns the hypergeometric distribution](https://support.microsoft.com/en-us/office/hypgeomdist-function-23e37961-2871-4195-9629-d0b2c108a12e)
Acronym Identity.From [Power Query M: Creates an identity.](https://docs.microsoft.com/en-us/powerquery-m/identity.from)
Acronym Identity.IsMemberOf [Power Query M: Determines whether an identity is a member of an identity collection.](https://docs.microsoft.com/en-us/powerquery-m/identity-ismemberof)
Acronym IdentityProvider.Default [Power Query M: The default identity provider for the current host.](https://docs.microsoft.com/en-us/powerquery-m/identityprovider-default)
Acronym IF [Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)
Acronym IFERROR [Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula](https://support.microsoft.com/en-us/office/iferror-function-c526fd07-caeb-47b8-8bb6-63f3e417f611)
Acronym IFNA [Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression](https://support.microsoft.com/en-us/office/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461)
Acronym IFS [Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.](https://support.microsoft.com/en-us/office/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45)
Acronym IMABS [Returns the absolute value (modulus) of a complex number](https://support.microsoft.com/en-us/office/imabs-function-b31e73c6-d90c-4062-90bc-8eb351d765a1)
Acronym IMAGINARY [Returns the imaginary coefficient of a complex number](https://support.microsoft.com/en-us/office/imaginary-function-dd5952fd-473d-44d9-95a1-9a17b23e428a)
Acronym IMARGUMENT [Returns the argument theta, an angle expressed in radians](https://support.microsoft.com/en-us/office/imargument-function-eed37ec1-23b3-4f59-b9f3-d340358a034a)
Acronym IMCONJUGATE [Returns the complex conjugate of a complex number](https://support.microsoft.com/en-us/office/imconjugate-function-2e2fc1ea-f32b-4f9b-9de6-233853bafd42)
Acronym IMCOS [Returns the cosine of a complex number](https://support.microsoft.com/en-us/office/imcos-function-dad75277-f592-4a6b-ad6c-be93a808a53c)
Acronym IMCOSH [Returns the hyperbolic cosine of a complex number](https://support.microsoft.com/en-us/office/imcosh-function-053e4ddb-4122-458b-be9a-457c405e90ff)
Acronym IMCOT [Returns the cotangent of a complex number](https://support.microsoft.com/en-us/office/imcot-function-dc6a3607-d26a-4d06-8b41-8931da36442c)
Acronym IMCSC [Returns the cosecant of a complex number](https://support.microsoft.com/en-us/office/imcsc-function-9e158d8f-2ddf-46cd-9b1d-98e29904a323)
Acronym IMCSCH [Returns the hyperbolic cosecant of a complex number](https://support.microsoft.com/en-us/office/imcsch-function-c0ae4f54-5f09-4fef-8da0-dc33ea2c5ca9)
Acronym IMDIV [Returns the quotient of two complex numbers](https://support.microsoft.com/en-us/office/imdiv-function-a505aff7-af8a-4451-8142-77ec3d74d83f)
Acronym IMEXP [Returns the exponential of a complex number](https://support.microsoft.com/en-us/office/imexp-function-c6f8da1f-e024-4c0c-b802-a60e7147a95f)
Acronym IMLN [Returns the natural logarithm of a complex number](https://support.microsoft.com/en-us/office/imln-function-32b98bcf-8b81-437c-a636-6fb3aad509d8)
Acronym IMLOG10 [Returns the base-10 logarithm of a complex number](https://support.microsoft.com/en-us/office/imlog10-function-58200fca-e2a2-4271-8a98-ccd4360213a5)
Acronym IMLOG2 [Returns the base-2 logarithm of a complex number](https://support.microsoft.com/en-us/office/imlog2-function-152e13b4-bc79-486c-a243-e6a676878c51)
Acronym IMPOWER [Returns a complex number raised to an integer power](https://support.microsoft.com/en-us/office/impower-function-210fd2f5-f8ff-4c6a-9d60-30e34fbdef39)
Acronym IMPRODUCT [Returns the product of complex numbers](https://support.microsoft.com/en-us/office/improduct-function-2fb8651a-a4f2-444f-975e-8ba7aab3a5ba)
Acronym IMREAL [Returns the real coefficient of a complex number](https://support.microsoft.com/en-us/office/imreal-function-d12bc4c0-25d0-4bb3-a25f-ece1938bf366)
Acronym IMSEC [Returns the secant of a complex number](https://support.microsoft.com/en-us/office/imsec-function-6df11132-4411-4df4-a3dc-1f17372459e0)
Acronym IMSECH [Returns the hyperbolic secant of a complex number](https://support.microsoft.com/en-us/office/imsech-function-f250304f-788b-4505-954e-eb01fa50903b)
Acronym IMSIN [Returns the sine of a complex number](https://support.microsoft.com/en-us/office/imsin-function-1ab02a39-a721-48de-82ef-f52bf37859f6)
Acronym IMSINH [Returns the hyperbolic sine of a complex number](https://support.microsoft.com/en-us/office/imsinh-function-dfb9ec9e-8783-4985-8c42-b028e9e8da3d)
Acronym IMSQRT [Returns the square root of a complex number](https://support.microsoft.com/en-us/office/imsqrt-function-e1753f80-ba11-4664-a10e-e17368396b70)
Acronym IMSUB [Returns the difference between two complex numbers](https://support.microsoft.com/en-us/office/imsub-function-2e404b4d-4935-4e85-9f52-cb08b9a45054)
Acronym IMSUM [Returns the sum of complex numbers](https://support.microsoft.com/en-us/office/imsum-function-81542999-5f1c-4da6-9ffe-f1d7aaa9457f)
Acronym IMTAN [Returns the tangent of a complex number](https://support.microsoft.com/en-us/office/imtan-function-8478f45d-610a-43cf-8544-9fc0b553a132)
Acronym INDEX [Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)
Acronym INDIRECT [Returns a reference indicated by a text value](https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261)
Acronym INFO [Returns information about the current operating environment](https://support.microsoft.com/en-us/office/info-function-725f259a-0e4b-49b3-8b52-58815c69acae)
Acronym Informix.Database [Power Query M: Returns a table of SQL tables and views available in an Informix database on server server in the database instance named database.](https://docs.microsoft.com/en-us/powerquery-m/informix-database)
Acronym INT [Rounds a number down to the nearest integer](https://support.microsoft.com/en-us/office/int-function-a6c4af9e-356d-4369-ab6a-cb1fd9d343ef)
Acronym Int16.From [Power Query M: Returns a 16-bit integer number value from the given value.](https://docs.microsoft.com/en-us/powerquery-m/int16-from)
Acronym Int32.From [Power Query M: Returns a 32-bit integer number value from the given value.](https://docs.microsoft.com/en-us/powerquery-m/int32-from)
Acronym Int64.From [Power Query M: Returns a 64-bit integer number value from the given value.](https://docs.microsoft.com/en-us/powerquery-m/int64-from)
Acronym Int8.From [Power Query M: Returns a signed 8-bit integer number value from the given value.](https://docs.microsoft.com/en-us/powerquery-m/int8-from)
Acronym INTERCEPT [Returns the intercept of the linear regression line](https://support.microsoft.com/en-us/office/intercept-function-2a9b74e2-9d47-4772-b663-3bca70bf63ef)
Acronym INTRATE [Returns the interest rate for a fully invested security](https://support.microsoft.com/en-us/office/intrate-function-5cb34dde-a221-4cb6-b3eb-0b9e55e1316f)
Acronym IPMT [Returns the interest payment for an investment for a given period](https://support.microsoft.com/en-us/office/ipmt-function-5cce0ad6-8402-4a41-8d29-61a0b054cb6f)
Acronym IRR [Returns the internal rate of return for a series of cash flows](https://support.microsoft.com/en-us/office/irr-function-64925eaa-9988-495b-b290-3ad0c163c1bc)
Acronym ISBLANK [Returns TRUE if the value is blank](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)
Acronym ISERR [Returns TRUE if the value is any error value except #N/A](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)
Acronym ISERROR [Returns TRUE if the value is any error value](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)
Acronym ISEVEN [Returns TRUE if the number is even](https://support.microsoft.com/en-us/office/iseven-function-aa15929a-d77b-4fbb-92f4-2f479af55356)
Acronym ISFORMULA [Returns TRUE if there is a reference to a cell that contains a formula](https://support.microsoft.com/en-us/office/isformula-function-e4d1355f-7121-4ef2-801e-3839bfd6b1e5)
Acronym ISLOGICAL [Returns TRUE if the value is a logical value](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)
Acronym ISNA [Returns TRUE if the value is the #N/A error value](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)
Acronym ISNONTEXT [Returns TRUE if the value is not text](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)
Acronym ISNUMBER [Returns TRUE if the value is a number](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)
Acronym ISO.CEILING [Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance](https://support.microsoft.com/en-us/office/iso-ceiling-function-e587bb73-6cc2-4113-b664-ff5b09859a83)
Acronym ISODD [Returns TRUE if the number is odd](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)
Acronym ISOWEEKNUM [Returns the number of the ISO week number of the year for a given date](https://support.microsoft.com/en-us/office/isoweeknum-function-1c2d0afe-d25b-4ab1-8894-8d0520e90e0e)
Acronym ISPMT [Calculates the interest paid during a specific period of an investment](https://support.microsoft.com/en-us/office/ispmt-function-fa58adb6-9d39-4ce0-8f43-75399cea56cc)
Acronym ISREF [Returns TRUE if the value is a reference](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)
Acronym ISTEXT [Returns TRUE if the value is text](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)
Acronym ItemExpression.From [Power Query M: Returns the AST for the body of a function.](https://docs.microsoft.com/en-us/powerquery-m/itemexpression-from)
Acronym ItemExpression.Item [Power Query M: An AST node representing the item in an item expression.](https://docs.microsoft.com/en-us/powerquery-m/itemexpression-item)
Acronym JIS [Changes half-width (single-byte) characters within a string to full-width (double-byte) characters](https://support.microsoft.com/en-us/office/jis-function-b72fb1a7-ba52-448a-b7d3-d2610868b7e2)
Acronym JoinAlgorithm.Dynamic [Power Query M: JoinAlgorithm.Dynamic](https://docs.microsoft.com/en-us/powerquery-m/joinalgorithm-dynamic)
Acronym JoinAlgorithm.LeftHash [Power Query M: JoinAlgorithm.LeftHash](https://docs.microsoft.com/en-us/powerquery-m/joinalgorithm-lefthash)
Acronym JoinAlgorithm.LeftIndex [Power Query M: JoinAlgorithm.LeftIndex](https://docs.microsoft.com/en-us/powerquery-m/joinalgorithm-leftindex)
Acronym JoinAlgorithm.PairwiseHash [Power Query M: JoinAlgorithm.PairwiseHash](https://docs.microsoft.com/en-us/powerquery-m/joinalgorithm-pairwisehash)
Acronym JoinAlgorithm.RightHash [Power Query M: JoinAlgorithm.RightHash](https://docs.microsoft.com/en-us/powerquery-m/joinalgorithm-righthash)
Acronym JoinAlgorithm.RightIndex [Power Query M: JoinAlgorithm.RightIndex](https://docs.microsoft.com/en-us/powerquery-m/joinalgorithm-rightindex)
Acronym JoinAlgorithm.SortMerge [Power Query M: JoinAlgorithm.SortMerge](https://docs.microsoft.com/en-us/powerquery-m/joinalgorithm-sortmerge)
Acronym JoinKind.FullOuter [Power Query M: A possible value for the optional JoinKind parameter in Table.Join. A full outer join ensures that all rows of both tables appear in the result. Rows that did not have a match in the other table are joined with a default row containing null values for all of its columns.](https://docs.microsoft.com/en-us/powerquery-m/joinkind-fullouter)
Acronym JoinKind.Inner [Power Query M: A possible value for the optional JoinKind parameter in Table.Join. The table resulting from an inner join contains a row for each pair of rows from the specified tables that were determined to match based on the specified key columns.](https://docs.microsoft.com/en-us/powerquery-m/joinkind-inner)
Acronym JoinKind.LeftAnti [Power Query M: A possible value for the optional JoinKind parameter in Table.Join. A left anti join returns that all rows from the first table which do not have a match in the second table.](https://docs.microsoft.com/en-us/powerquery-m/joinkind-leftanti)
Acronym JoinKind.LeftOuter [Power Query M: A possible value for the optional JoinKind parameter in Table.Join. A left outer join ensures that all rows of the first table appear in the result.](https://docs.microsoft.com/en-us/powerquery-m/joinkind-leftouter)
Acronym JoinKind.RightAnti [Power Query M: A possible value for the optional JoinKind parameter in Table.Join. A right anti join returns that all rows from the second table which do not have a match in the first table.](https://docs.microsoft.com/en-us/powerquery-m/joinkind-rightanti)
Acronym JoinKind.RightOuter [Power Query M: A possible value for the optional JoinKind parameter in Table.Join. A right outer join ensures that all rows of the second table appear in the result.](https://docs.microsoft.com/en-us/powerquery-m/joinkind-rightouter)
Acronym JoinSide.Left [Power Query M: Specifies the left table of a join.](https://docs.microsoft.com/en-us/powerquery-m/joinside-left)
Acronym JoinSide.Right [Power Query M: Specifies the right table of a join.](https://docs.microsoft.com/en-us/powerquery-m/joinside-right)
Acronym Json.Document [Power Query M: Returns the contents of a JSON document. The contents may be directly passed to the function as text, or it may be the binary value returned by a function like File.Contents.](https://docs.microsoft.com/en-us/powerquery-m/json-document)
Acronym Json.FromValue [Power Query M: Produces a JSON representation of a given value value with a text encoding specified by encoding.](https://docs.microsoft.com/en-us/powerquery-m/json-fromvalue)
Acronym KURT [Returns the kurtosis of a data set](https://support.microsoft.com/en-us/office/kurt-function-bc3a265c-5da4-4dcb-b7fd-c237789095ab)
Acronym LARGE [Returns the k-th largest value in a data set](https://support.microsoft.com/en-us/office/large-function-3af0af19-1190-42bb-bb8b-01672ec00a64)
Acronym LCM [Returns the least common multiple](https://support.microsoft.com/en-us/office/lcm-function-7152b67a-8bb5-4075-ae5c-06ede5563c94)
Acronym LEFT [Returns the leftmost characters from a text value](https://support.microsoft.com/en-us/office/left-leftb-functions-9203d2d2-7960-479b-84c6-1ea52b99640c)
Acronym LEFTB [Returns the leftmost characters from a text value](https://support.microsoft.com/en-us/office/left-leftb-functions-9203d2d2-7960-479b-84c6-1ea52b99640c)
Acronym LEN [Returns the number of characters in a text string](https://support.microsoft.com/en-us/office/len-lenb-functions-29236f94-cedc-429d-affd-b5e33d2c67cb)
Acronym LENB [Returns the number of characters in a text string](https://support.microsoft.com/en-us/office/len-lenb-functions-29236f94-cedc-429d-affd-b5e33d2c67cb)
Acronym Lines.FromBinary [Power Query M: Converts a binary value to a list of text values split at lines breaks.](https://docs.microsoft.com/en-us/powerquery-m/lines-frombinary)
Acronym Lines.FromText [Power Query M: Converts a text value to a list of text values split at lines breaks.](https://docs.microsoft.com/en-us/powerquery-m/lines-fromtext)
Acronym Lines.ToBinary [Power Query M: Converts a list of text into a binary value using the specified encoding and lineSeparator.The specified lineSeparator is appended to each line. If not specified then the carriage return and line feed characters are used.](https://docs.microsoft.com/en-us/powerquery-m/lines-tobinary)
Acronym Lines.ToText [Power Query M: Converts a list of text into a single text. The specified lineSeparator is appended to each line. If not specified then the carriage return and line feed characters are used.](https://docs.microsoft.com/en-us/powerquery-m/lines-totext)
Acronym LINEST [Returns the parameters of a linear trend](https://support.microsoft.com/en-us/office/linest-function-84d7d0d9-6e50-4101-977a-fa7abf772b6d)
Acronym List.Accumulate [Power Query M: Accumulates a result from the list. Starting from the initial value seed this function applies the accumulator function and returns the final result.](https://docs.microsoft.com/en-us/powerquery-m/list-accumulate)
Acronym List.AllTrue [Power Query M: Returns true if all expressions in a list are true](https://docs.microsoft.com/en-us/powerquery-m/list-alltrue)
Acronym List.Alternate [Power Query M: Returns a list with the items alternated from the original list based on a count, optional repeatInterval, and an optional offset.](https://docs.microsoft.com/en-us/powerquery-m/list-alternate)
Acronym List.AnyTrue [Power Query M: Returns true if any expression in a list in true](https://docs.microsoft.com/en-us/powerquery-m/list-anytrue)
Acronym List.Average [Power Query M: Returns an average value from a list in the datatype of the values in the list.](https://docs.microsoft.com/en-us/powerquery-m/list-average)
Acronym List.Buffer [Power Query M: Buffers the list in memory. The result of this call is a stable list, which means it will have a determinimic count, and order of items.](https://docs.microsoft.com/en-us/powerquery-m/list-buffer)
Acronym List.Combine [Power Query M: Merges a list of lists into single list.](https://docs.microsoft.com/en-us/powerquery-m/list-combine)
Acronym List.Contains [Power Query M: Returns true if a value is found in a list.](https://docs.microsoft.com/en-us/powerquery-m/list-contains)
Acronym List.ContainsAll [Power Query M: Returns true if all items in values are found in a list.](https://docs.microsoft.com/en-us/powerquery-m/list-containsall)
Acronym List.ContainsAny [Power Query M: Returns true if any item in values is found in a list.](https://docs.microsoft.com/en-us/powerquery-m/list-containsany)
Acronym List.Count [Power Query M: Returns the number of items in a list.](https://docs.microsoft.com/en-us/powerquery-m/list-count)
Acronym List.Covariance [Power Query M: Returns the covariance from two lists as a number.](https://docs.microsoft.com/en-us/powerquery-m/list-covariance)
Acronym List.Dates [Power Query M: Returns a list of date values from size count, starting at start and adds an increment to every value.](https://docs.microsoft.com/en-us/powerquery-m/list-dates)
Acronym List.DateTimes [Power Query M: Returns a list of datetime values from size count, starting at start and adds an increment to every value.](https://docs.microsoft.com/en-us/powerquery-m/list-datetimes)
Acronym List.DateTimeZones [Power Query M: Returns a list of of datetimezone values from size count, starting at start and adds an increment to every value.](https://docs.microsoft.com/en-us/powerquery-m/list-datetimezones)
Acronym List.Difference [Power Query M: Returns the items in list 1 that do not appear in list 2. Duplicate values are supported.](https://docs.microsoft.com/en-us/powerquery-m/list-difference)
Acronym List.Distinct [Power Query M: Filters a list down by removing duplicates. An optional equation criteria value can be specified to control equality comparison. The first value from each equality group is chosen.](https://docs.microsoft.com/en-us/powerquery-m/list-distinct)
Acronym List.Durations [Power Query M: Returns a list of durations values from size count, starting at start and adds an increment to every value.](https://docs.microsoft.com/en-us/powerquery-m/list-durations)
Acronym List.FindText [Power Query M: Searches a list of values, including record fields, for a text value.](https://docs.microsoft.com/en-us/powerquery-m/list-findtext)
Acronym List.First [Power Query M: Returns the first value of the list or the specified default if empty. Returns the first item in the list, or the optional default value, if the list is empty. If the list is empty and a default value is not specified, the function returns.](https://docs.microsoft.com/en-us/powerquery-m/list-first)
Acronym List.FirstN [Power Query M: Returns the first set of items in the list by specifying how many items to return or a qualifying condition provided by countOrCondition.](https://docs.microsoft.com/en-us/powerquery-m/list-firstn)
Acronym List.Generate [Power Query M: Generates a list from a value function, a condition function, a next function, and an optional transformation function on the values.](https://docs.microsoft.com/en-us/powerquery-m/list-generate)
Acronym List.InsertRange [Power Query M: Inserts items from values at the given index in the input list.](https://docs.microsoft.com/en-us/powerquery-m/list-insertrange)
Acronym List.Intersect [Power Query M: Returns a list from a list of lists and intersects common items in individual lists. Duplicate values are supported.](https://docs.microsoft.com/en-us/powerquery-m/list-intersect)
Acronym List.IsDistinct [Power Query M: Returns whether a list is distinct.](https://docs.microsoft.com/en-us/powerquery-m/list-isdistinct)
Acronym List.IsEmpty [Power Query M: Returns whether a list is empty.](https://docs.microsoft.com/en-us/powerquery-m/list-isempty)
Acronym List.Last [Power Query M: Returns the last set of items in the list by specifying how many items to return or a qualifying condition provided by countOrCondition.](https://docs.microsoft.com/en-us/powerquery-m/list-last)
Acronym List.LastN [Power Query M: Returns the last set of items in a list by specifying how many items to return or a qualifying condition.](https://docs.microsoft.com/en-us/powerquery-m/list-lastn)
Acronym List.MatchesAll [Power Query M: Returns true if all items in a list meet a condition.](https://docs.microsoft.com/en-us/powerquery-m/list-matchesall)
Acronym List.MatchesAny [Power Query M: Returns true if any item in a list meets a condition.](https://docs.microsoft.com/en-us/powerquery-m/list-matchesany)
Acronym List.Max [Power Query M: Returns the maximum item in a list, or the optional default value if the list is empty.](https://docs.microsoft.com/en-us/powerquery-m/list-max)
Acronym List.MaxN [Power Query M: Returns the maximum values in the list. After the rows are sorted, optional parameters may be specified to further filter the result](https://docs.microsoft.com/en-us/powerquery-m/list-maxn)
Acronym List.Median [Power Query M: Returns the median item from a list.](https://docs.microsoft.com/en-us/powerquery-m/list-median)
Acronym List.Min [Power Query M: Returns the minimum item in a list, or the optional default value if the list is empty.](https://docs.microsoft.com/en-us/powerquery-m/list-min)
Acronym List.MinN [Power Query M: Returns the minimum values in a list.](https://docs.microsoft.com/en-us/powerquery-m/list-minn)
Acronym List.Mode [Power Query M: Returns an item that appears most commonly in a list.](https://docs.microsoft.com/en-us/powerquery-m/list-mode)
Acronym List.Modes [Power Query M: Returns all items that appear with the same maximum frequency.](https://docs.microsoft.com/en-us/powerquery-m/list-modes)
Acronym List.NonNullCount [Power Query M: Returns the number of items in a list excluding null values](https://docs.microsoft.com/en-us/powerquery-m/list-nonnullcount)
Acronym List.Numbers [Power Query M: Returns a list of numbers from size count starting at initial, and adds an increment. The increment defaults to 1.](https://docs.microsoft.com/en-us/powerquery-m/list-numbers)
Acronym List.PositionOf [Power Query M: Finds the first occurrence of a value in a list and returns its position.](https://docs.microsoft.com/en-us/powerquery-m/list-positionof)
Acronym List.PositionOfAny [Power Query M: Finds the first occurrence of any value in values and returns its position.](https://docs.microsoft.com/en-us/powerquery-m/list-positionofany)
Acronym List.Positions [Power Query M: Returns a list of positions for an input list.](https://docs.microsoft.com/en-us/powerquery-m/list-positions)
Acronym List.Product [Power Query M: Returns the product from a list of numbers.](https://docs.microsoft.com/en-us/powerquery-m/list-product)
Acronym List.Random [Power Query M: Returns a list of count random numbers, with an optional seed parameter.](https://docs.microsoft.com/en-us/powerquery-m/list-random)
Acronym List.Range [Power Query M: Returns a count items starting at an offset.](https://docs.microsoft.com/en-us/powerquery-m/list-range)
Acronym List.RemoveFirstN [Power Query M: Returns a list with the specified number of elements removed from the list starting at the first element. The number of elements removed depends on the optional countOrCondition parameter.](https://docs.microsoft.com/en-us/powerquery-m/list-removefirstn)
Acronym List.RemoveItems [Power Query M: Removes items from list1 that are present in list2, and returns a new list.](https://docs.microsoft.com/en-us/powerquery-m/list-removeitems)
Acronym List.RemoveLastN [Power Query M: Returns a list with the specified number of elements removed from the list starting at the last element. The number of elements removed depends on the optional countOrCondition parameter.](https://docs.microsoft.com/en-us/powerquery-m/list-removelastn)
Acronym List.RemoveMatchingItems [Power Query M: Removes all occurrences of the given values in the list.](https://docs.microsoft.com/en-us/powerquery-m/list-removematchingitems)
Acronym List.RemoveNulls [Power Query M: Removes null values from a list.](https://docs.microsoft.com/en-us/powerquery-m/list-removenulls)
Acronym List.RemoveRange [Power Query M: Returns a list that removes count items starting at offset. The default count is 1.](https://docs.microsoft.com/en-us/powerquery-m/list-removerange)
Acronym List.Repeat [Power Query M: Returns a list that repeats the contents of an input list count times.](https://docs.microsoft.com/en-us/powerquery-m/list-repeat)
Acronym List.ReplaceMatchingItems [Power Query M: Replaces occurrences of existing values in the list with new values using the provided equationCriteria. Old and new values are provided by the replacements parameters. An optional equation criteria value can be specified to control equality comparisons. For details of replacement operations and equation criteria, see Parameter Values.](https://docs.microsoft.com/en-us/powerquery-m/list-replacematchingitems)
Acronym List.ReplaceRange [Power Query M: Returns a list that replaces count values in a list with a replaceWith list starting at an index.](https://docs.microsoft.com/en-us/powerquery-m/list-replacerange)
Acronym List.ReplaceValue [Power Query M: Searches a list of values for the value and replaces each occurrence with the replacement value.](https://docs.microsoft.com/en-us/powerquery-m/list-replacevalue)
Acronym List.Reverse [Power Query M: Returns a list that reverses the items in a list.](https://docs.microsoft.com/en-us/powerquery-m/list-reverse)
Acronym List.Select [Power Query M: Selects the items that match a condition.](https://docs.microsoft.com/en-us/powerquery-m/list-select)
Acronym List.Single [Power Query M: Returns the single item of the list or throws an Expression.Error if the list has more than one item.](https://docs.microsoft.com/en-us/powerquery-m/list-single)
Acronym List.SingleOrDefault [Power Query M: Returns a single item from a list.](https://docs.microsoft.com/en-us/powerquery-m/list-singleordefault)
Acronym List.Skip [Power Query M: Skips the first item of the list. Given an empty list, it returns an empty list. This function takes an optional parameter countOrCondition to support skipping multiple values.](https://docs.microsoft.com/en-us/powerquery-m/list-skip)
Acronym List.Sort [Power Query M: Returns a sorted list using comparison criterion.](https://docs.microsoft.com/en-us/powerquery-m/list-sort)
Acronym List.Split [Power Query M: Splits the specified list into a list of lists using the specified page size.](https://docs.microsoft.com/en-us/powerquery-m/list-split)
Acronym List.StandardDeviation [Power Query M: Returns the standard deviation from a list of values. List.StandardDeviation performs a sample based estimate. The result is a number for numbers, and a duration for DateTimes and Durations.](https://docs.microsoft.com/en-us/powerquery-m/list-standarddeviation)
Acronym List.Sum [Power Query M: Returns the sum from a list.](https://docs.microsoft.com/en-us/powerquery-m/list-sum)
Acronym List.Times [Power Query M: Returns a list of time values of size count, starting at start.](https://docs.microsoft.com/en-us/powerquery-m/list-times)
Acronym List.Transform [Power Query M: Performs the function on each item in the list and returns the new list.](https://docs.microsoft.com/en-us/powerquery-m/list-transform)
Acronym List.TransformMany [Power Query M: Returns a list whose elements are projected from the input list.](https://docs.microsoft.com/en-us/powerquery-m/list-transformmany)
Acronym List.Union [Power Query M: Returns a list from a list of lists and unions the items in the individual lists. The returned list contains all items in any input lists. Duplicate values are matched as part of the Union.](https://docs.microsoft.com/en-us/powerquery-m/list-union)
Acronym List.Zip [Power Query M: Returns a list of lists combining items at the same position.](https://docs.microsoft.com/en-us/powerquery-m/list-zip)
Acronym LN [Returns the natural logarithm of a number](https://support.microsoft.com/en-us/office/ln-function-81fe1ed7-dac9-4acd-ba1d-07a142c6118f)
Acronym LOG [Returns the logarithm of a number to a specified base](https://support.microsoft.com/en-us/office/log-function-4e82f196-1ca9-4747-8fb0-6c4a3abb3280)
Acronym LOG10 [Returns the base-10 logarithm of a number](https://support.microsoft.com/en-us/office/log10-function-c75b881b-49dd-44fb-b6f4-37e3486a0211)
Acronym LOGEST [Returns the parameters of an exponential trend](https://support.microsoft.com/en-us/office/logest-function-f27462d8-3657-4030-866b-a272c1d18b4b)
Acronym Logical.From [Power Query M: Returns a logical value from a value.](https://docs.microsoft.com/en-us/powerquery-m/logical-from)
Acronym Logical.FromText [Power Query M: Returns a logical value of true or false from a text value.](https://docs.microsoft.com/en-us/powerquery-m/logical-fromtext)
Acronym Logical.ToText [Power Query M: Returns a text value from a logical value.](https://docs.microsoft.com/en-us/powerquery-m/logical-totext)
Acronym LOGINV [Returns the inverse of the lognormal cumulative distribution](https://support.microsoft.com/en-us/office/loginv-function-0bd7631a-2725-482b-afb4-de23df77acfe)
Acronym LOGNORM.DIST [Returns the cumulative lognormal distribution](https://support.microsoft.com/en-us/office/lognorm-dist-function-eb60d00b-48a9-4217-be2b-6074aee6b070)
Acronym LOGNORM.INV [Returns the inverse of the lognormal cumulative distribution](https://support.microsoft.com/en-us/office/lognorm-inv-function-fe79751a-f1f2-4af8-a0a1-e151b2d4f600)
Acronym LOGNORMDIST [Returns the cumulative lognormal distribution](https://support.microsoft.com/en-us/office/lognormdist-function-f8d194cb-9ee3-4034-8c75-1bdb3884100b)
Acronym LOOKUP [Looks up values in a vector or array](https://support.microsoft.com/en-us/office/lookup-function-446d94af-663b-451d-8251-369d5e3864cb)
Acronym LOWER [Converts text to lowercase](https://support.microsoft.com/en-us/office/lower-function-3f21df02-a80c-44b2-afaf-81358f9fdeb4)
Acronym MATCH [Looks up values in a reference or array](https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a)
Acronym MAX [Returns the maximum value in a list of arguments](https://support.microsoft.com/en-us/office/max-function-e0012414-9ac8-4b34-9a47-73e662c08098)
Acronym MAXA [Returns the maximum value in a list of arguments, including numbers, text, and logical values](https://support.microsoft.com/en-us/office/maxa-function-814bda1e-3840-4bff-9365-2f59ac2ee62d)
Acronym MAXIFS [Returns the maximum value among cells specified by a given set of conditions or criteria](https://support.microsoft.com/en-us/office/maxifs-function-dfd611e6-da2c-488a-919b-9b6376b28883)
Acronym MDETERM [Returns the matrix determinant of an array](https://support.microsoft.com/en-us/office/mdeterm-function-e7bfa857-3834-422b-b871-0ffd03717020)
Acronym MDURATION [Returns the Macauley modified duration for a security with an assumed par value of $100](https://support.microsoft.com/en-us/office/mduration-function-b3786a69-4f20-469a-94ad-33e5b90a763c)
Acronym MEDIAN [Returns the median of the given numbers](https://support.microsoft.com/en-us/office/median-function-d0916313-4753-414c-8537-ce85bdd967d2)
Acronym MID [Returns a specific number of characters from a text string starting at the position you specify](https://support.microsoft.com/en-us/office/mid-midb-functions-d5f9e25c-d7d6-472e-b568-4ecb12433028)
Acronym MIDB [Returns a specific number of characters from a text string starting at the position you specify](https://support.microsoft.com/en-us/office/mid-midb-functions-d5f9e25c-d7d6-472e-b568-4ecb12433028)
Acronym MIN [Returns the minimum value in a list of arguments](https://support.microsoft.com/en-us/office/min-function-61635d12-920f-4ce2-a70f-96f202dcc152)
Acronym MINA [Returns the smallest value in a list of arguments, including numbers, text, and logical values](https://support.microsoft.com/en-us/office/mina-function-245a6f46-7ca5-4dc7-ab49-805341bc31d3)
Acronym MINIFS [Returns the minimum value among cells specified by a given set of conditions or criteria.](https://support.microsoft.com/en-us/office/minifs-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599)
Acronym MINUTE [Converts a serial number to a minute](https://support.microsoft.com/en-us/office/minute-function-af728df0-05c4-4b07-9eed-a84801a60589)
Acronym MINVERSE [Returns the matrix inverse of an array](https://support.microsoft.com/en-us/office/minverse-function-11f55086-adde-4c9f-8eb9-59da2d72efc6)
Acronym MIRR [Returns the internal rate of return where positive and negative cash flows are financed at different rates](https://support.microsoft.com/en-us/office/mirr-function-b020f038-7492-4fb4-93c1-35c345b53524)
Acronym MissingField.Error [Power Query M: An optional parameter in record and table functions indicating that missing fields should result in an error. (This is the default parameter value.)](https://docs.microsoft.com/en-us/powerquery-m/missingfield-error)
Acronym MissingField.Ignore [Power Query M: An optional parameter in record and table functions indicating that missing fields should be ignored.](https://docs.microsoft.com/en-us/powerquery-m/missingfield-ignore)
Acronym MissingField.UseNull [Power Query M: An optional parameter in record and table functions indicating that missing fields should be included as null values.](https://docs.microsoft.com/en-us/powerquery-m/missingfield-usenull)
Acronym MMULT [Returns the matrix product of two arrays](https://support.microsoft.com/en-us/office/mmult-function-40593ed7-a3cd-4b6b-b9a3-e4ad3c7245eb)
Acronym MOD [Returns the remainder from division](https://support.microsoft.com/en-us/office/mod-function-9b6cd169-b6ee-406a-a97b-edf2a9dc24f3)
Acronym MODE [Returns the most common value in a data set](https://support.microsoft.com/en-us/office/mode-function-e45192ce-9122-4980-82ed-4bdc34973120)
Acronym MODE.MULT [Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data](https://support.microsoft.com/en-us/office/mode-mult-function-50fd9464-b2ba-4191-b57a-39446689ae8c)
Acronym MODE.SNGL [Returns the most common value in a data set](https://support.microsoft.com/en-us/office/mode-sngl-function-f1267c16-66c6-4386-959f-8fba5f8bb7f8)
Acronym MONTH [Converts a serial number to a month](https://support.microsoft.com/en-us/office/month-function-579a2881-199b-48b2-ab90-ddba0eba86e8)
Acronym MROUND [Returns a number rounded to the desired multiple](https://support.microsoft.com/en-us/office/mround-function-c299c3b0-15a5-426d-aa4b-d2d5b3baf427)
Acronym MULTINOMIAL [Returns the multinomial of a set of numbers](https://support.microsoft.com/en-us/office/multinomial-function-6fa6373c-6533-41a2-a45e-a56db1db1bf6)
Acronym MUNIT [Returns the unit matrix or the specified dimension](https://support.microsoft.com/en-us/office/munit-function-c9fe916a-dc26-4105-997d-ba22799853a3)
Acronym MySQL.Database [Power Query M: Returns a table with data relating to the tables in the specified MySQL Database.](https://docs.microsoft.com/en-us/powerquery-m/mysql-database)
Acronym N [Returns a value converted to a number](https://support.microsoft.com/en-us/office/n-function-a624cad1-3635-4208-b54a-29733d1278c9)
Acronym NA [Returns the error value #N/A](https://support.microsoft.com/en-us/office/na-function-5469c2d1-a90c-4fb5-9bbc-64bd9bb6b47c)
Acronym NEGBINOM.DIST [Returns the negative binomial distribution](https://support.microsoft.com/en-us/office/negbinom-dist-function-c8239f89-c2d0-45bd-b6af-172e570f8599)
Acronym NEGBINOMDIST [Returns the negative binomial distribution](https://support.microsoft.com/en-us/office/negbinomdist-function-f59b0a37-bae2-408d-b115-a315609ba714)
Acronym NETWORKDAYS [Returns the number of whole workdays between two dates](https://support.microsoft.com/en-us/office/networkdays-function-48e717bf-a7a3-495f-969e-5005e3eb18e7)
Acronym NETWORKDAYS.INTL [Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days](https://support.microsoft.com/en-us/office/networkdays-intl-function-a9b26239-4f20-46a1-9ab8-4e925bfd5e28)
Acronym NOMINAL [Returns the annual nominal interest rate](https://support.microsoft.com/en-us/office/nominal-function-7f1ae29b-6b92-435e-b950-ad8b190ddd2b)
Acronym NORM.DIST [Returns the normal cumulative distribution](https://support.microsoft.com/en-us/office/norm-dist-function-edb1cc14-a21c-4e53-839d-8082074c9f8d)
Acronym NORM.INV [Returns the inverse of the normal cumulative distribution](https://support.microsoft.com/en-us/office/norm-inv-function-54b30935-fee7-493c-bedb-2278a9db7e13)
Acronym NORM.S.DIST [Returns the standard normal cumulative distribution](https://support.microsoft.com/en-us/office/norm-s-dist-function-1e787282-3832-4520-a9ae-bd2a8d99ba88)
Acronym NORM.S.INV [Returns the inverse of the standard normal cumulative distribution](https://support.microsoft.com/en-us/office/norm-s-inv-function-d6d556b4-ab7f-49cd-b526-5a20918452b1)
Acronym NORMDIST [Returns the normal cumulative distribution](https://support.microsoft.com/en-us/office/normdist-function-126db625-c53e-4591-9a22-c9ff422d6d58)
Acronym NORMINV [Returns the inverse of the normal cumulative distribution](https://support.microsoft.com/en-us/office/norminv-function-87981ab8-2de0-4cb0-b1aa-e21d4cb879b8)
Acronym NORMSDIST [Returns the standard normal cumulative distribution](https://support.microsoft.com/en-us/office/normsdist-function-463369ea-0345-445d-802a-4ff0d6ce7cac)
Acronym NORMSINV [Returns the inverse of the standard normal cumulative distribution](https://support.microsoft.com/en-us/office/normsinv-function-8d1bce66-8e4d-4f3b-967c-30eed61f019d)
Acronym NOT [Reverses the logic of its argument](https://support.microsoft.com/en-us/office/not-function-9cfc6011-a054-40c7-a140-cd4ba2d87d77)
Acronym NOW [Returns the serial number of the current date and time](https://support.microsoft.com/en-us/office/now-function-3337fd29-145a-4347-b2e6-20c904739c46)
Acronym NPER [Returns the number of periods for an investment](https://support.microsoft.com/en-us/office/nper-function-240535b5-6653-4d2d-bfcf-b6a38151d815)
Acronym NPV [Returns the net present value of an investment based on a series of periodic cash flows and a discount rate](https://support.microsoft.com/en-us/office/npv-function-8672cb67-2576-4d07-b67b-ac28acf2a568)
Acronym Number.Abs [Power Query M: Returns the absolute value of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-abs)
Acronym Number.Acos [Power Query M: Returns the arccosine of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-acos)
Acronym Number.Asin [Power Query M: Returns the arcsine of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-asin)
Acronym Number.Atan [Power Query M: Returns the arctangent of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-atan)
Acronym Number.Atan2 [Power Query M: Returns the arctangent of the division of two numbers.](https://docs.microsoft.com/en-us/powerquery-m/number-atan2)
Acronym Number.BitwiseAnd [Power Query M: Returns the result of a bitwise AND operation on the provided operands.](https://docs.microsoft.com/en-us/powerquery-m/number-bitwiseand)
Acronym Number.BitwiseNot [Power Query M: Returns the result of a bitwise NOT operation on the provided operands.](https://docs.microsoft.com/en-us/powerquery-m/number-bitwisenot)
Acronym Number.BitwiseOr [Power Query M: Returns the result of a bitwise OR operation on the provided operands.](https://docs.microsoft.com/en-us/powerquery-m/number-bitwiseor)
Acronym Number.BitwiseShiftLeft [Power Query M: Returns the result of a bitwise shift left operation on the operands.](https://docs.microsoft.com/en-us/powerquery-m/number-bitwiseshiftleft)
Acronym Number.BitwiseShiftRight [Power Query M: Returns the result of a bitwise shift right operation on the operands.](https://docs.microsoft.com/en-us/powerquery-m/number-bitwiseshiftright)
Acronym Number.BitwiseXor [Power Query M: Returns the result of a bitwise XOR operation on the provided operands.](https://docs.microsoft.com/en-us/powerquery-m/number-bitwisexor)
Acronym Number.Combinations [Power Query M: Returns the number of combinations of a given number of items for the optional combination size.](https://docs.microsoft.com/en-us/powerquery-m/number-combinations)
Acronym Number.Cos [Power Query M: Returns the cosine of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-cos)
Acronym Number.Cosh [Power Query M: Returns the hyperbolic cosine of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-cosh)
Acronym Number.E [Power Query M: Returns 2.7182818284590451, the value of e up to 16 decimal digits.](https://docs.microsoft.com/en-us/powerquery-m/number-e)
Acronym Number.Epsilon [Power Query M: Returns the smallest possible number.](https://docs.microsoft.com/en-us/powerquery-m/number-epsilon)
Acronym Number.Exp [Power Query M: Returns a number representing e raised to a power.](https://docs.microsoft.com/en-us/powerquery-m/number-exp)
Acronym Number.Factorial [Power Query M: Returns the factorial of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-factorial)
Acronym Number.From [Power Query M: Returns a number value from a value.](https://docs.microsoft.com/en-us/powerquery-m/number-from)
Acronym Number.FromText [Power Query M: Returns a number value from a text value.](https://docs.microsoft.com/en-us/powerquery-m/number-fromtext)
Acronym Number.IntegerDivide [Power Query M: Divides two numbers and returns the whole part of the resulting number.](https://docs.microsoft.com/en-us/powerquery-m/number-integerdivide)
Acronym Number.IsEven [Power Query M: Returns true if a value is an even number.](https://docs.microsoft.com/en-us/powerquery-m/number-iseven)
Acronym Number.IsNaN [Power Query M: Returns true if a value is Number.NaN.](https://docs.microsoft.com/en-us/powerquery-m/number-isnan)
Acronym Number.IsOdd [Power Query M: Returns true if a value is an odd number.](https://docs.microsoft.com/en-us/powerquery-m/number-isodd)
Acronym Number.Ln [Power Query M: Returns the natural logarithm of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-ln)
Acronym Number.Log [Power Query M: Returns the logarithm of a number to the base.](https://docs.microsoft.com/en-us/powerquery-m/number-log)
Acronym Number.Log10 [Power Query M: Returns the base-10 logarithm of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-log10)
Acronym Number.Mod [Power Query M: Divides two numbers and returns the remainder of the resulting number.](https://docs.microsoft.com/en-us/powerquery-m/number-mod)
Acronym Number.NaN [Power Query M: Represents 0/0.](https://docs.microsoft.com/en-us/powerquery-m/number-nan)
Acronym Number.NegativeInfinity [Power Query M: Represents -1/0.](https://docs.microsoft.com/en-us/powerquery-m/number-negativeinfinity)
Acronym Number.Permutations [Power Query M: Returns the number of total permutatons of a given number of items for the optional permutation size.](https://docs.microsoft.com/en-us/powerquery-m/number-permutations)
Acronym Number.PI [Power Query M: Returns 3.1415926535897931, the value for Pi up to 16 decimal digits.](https://docs.microsoft.com/en-us/powerquery-m/number-pi)
Acronym Number.PositiveInfinity [Power Query M: Represents 1/0.](https://docs.microsoft.com/en-us/powerquery-m/number-positiveinfinity)
Acronym Number.Power [Power Query M: Returns a number raised by a power.](https://docs.microsoft.com/en-us/powerquery-m/number-power)
Acronym Number.Random [Power Query M: Returns a random fractional number between 0 and 1.](https://docs.microsoft.com/en-us/powerquery-m/number-random)
Acronym Number.RandomBetween [Power Query M: Returns a random number between the two given number values.](https://docs.microsoft.com/en-us/powerquery-m/number-randombetween)
Acronym Number.Round [Power Query M: Returns a nullable number (n) if value is an integer.](https://docs.microsoft.com/en-us/powerquery-m/number-round)
Acronym Number.RoundAwayFromZero [Power Query M: Returns Number.RoundUp(value) when value >= 0 and Number.RoundDown(value) when value < 0.](https://docs.microsoft.com/en-us/powerquery-m/number-roundawayfromzero)
Acronym Number.RoundDown [Power Query M: Returns the largest integer less than or equal to a number value.](https://docs.microsoft.com/en-us/powerquery-m/number-rounddown)
Acronym Number.RoundTowardZero [Power Query M: Returns Number.RoundDown(x) when x >= 0 and Number.RoundUp(x) when x < 0.](https://docs.microsoft.com/en-us/powerquery-m/number-roundtowardzero)
Acronym Number.RoundUp [Power Query M: Returns the larger integer greater than or equal to a number value.](https://docs.microsoft.com/en-us/powerquery-m/number-roundup)
Acronym Number.Sign [Power Query M: Returns 1 for positive numbers, -1 for negative numbers or 0 for zero.](https://docs.microsoft.com/en-us/powerquery-m/number-sign)
Acronym Number.Sin [Power Query M: Returns the sine of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-sin)
Acronym Number.Sinh [Power Query M: Returns the hyperbolic sine of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-sinh)
Acronym Number.Sqrt [Power Query M: Returns the square root of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-sqrt)
Acronym Number.Tan [Power Query M: Returns the tangent of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-tan)
Acronym Number.Tanh [Power Query M: Returns the hyperbolic tangent of a number.](https://docs.microsoft.com/en-us/powerquery-m/number-tanh)
Acronym Number.ToText [Power Query M: Returns a text value from a number value.](https://docs.microsoft.com/en-us/powerquery-m/number-totext)
Acronym NUMBERVALUE [Converts text to number in a locale-independent manner](https://support.microsoft.com/en-us/office/numbervalue-function-1b05c8cf-2bfa-4437-af70-596c7ea7d879)
Acronym Occurrence.All [Power Query M: A list of positions of all occurrences of the found values is returned.](https://docs.microsoft.com/en-us/powerquery-m/occurrence-all)
Acronym Occurrence.First [Power Query M: The position of the first occurrence of the found value is returned.](https://docs.microsoft.com/en-us/powerquery-m/occurrence-first)
Acronym Occurrence.Last [Power Query M: The position of the last occurrence of the found value is returned.](https://docs.microsoft.com/en-us/powerquery-m/occurrence-last)
Acronym Occurrence.Optional [Power Query M: The item is expected to appear zero or one time in the input.](https://docs.microsoft.com/en-us/powerquery-m/occurrence-optional)
Acronym Occurrence.Repeating [Power Query M: The item is expected to appear zero or more times in the input.](https://docs.microsoft.com/en-us/powerquery-m/occurrence-repeating)
Acronym Occurrence.Required [Power Query M: The item is expected to appear once in the input.](https://docs.microsoft.com/en-us/powerquery-m/occurrence-required)
Acronym OCT2BIN [Converts an octal number to binary](https://support.microsoft.com/en-us/office/oct2bin-function-55383471-3c56-4d27-9522-1a8ec646c589)
Acronym OCT2DEC [Converts an octal number to decimal](https://support.microsoft.com/en-us/office/oct2dec-function-87606014-cb98-44b2-8dbb-e48f8ced1554)
Acronym OCT2HEX [Converts an octal number to hexadecimal](https://support.microsoft.com/en-us/office/oct2hex-function-912175b4-d497-41b4-a029-221f051b858f)
Acronym OData.Feed [Power Query M: Returns a table of OData feeds offered by an OData serviceUri.](https://docs.microsoft.com/en-us/powerquery-m/odata-feed)
Acronym ODataOmitValues.Nulls [Power Query M: Allows the OData service to omit null values.](https://docs.microsoft.com/en-us/powerquery-m/odataomitvalues-nulls)
Acronym Odbc.DataSource [Power Query M: Returns a table of SQL tables and views from the ODBC data source specified by the connection string connectionString.](https://docs.microsoft.com/en-us/powerquery-m/odbc-datasource)
Acronym Odbc.InferOptions [Power Query M: Returns the result of trying to infer SQL capabilities for an ODBC driver.](https://docs.microsoft.com/en-us/powerquery-m/odbc-inferoptions)
Acronym Odbc.Query [Power Query M: Connects to a generic provider with the given connection string and returns the result of evaluating the query.](https://docs.microsoft.com/en-us/powerquery-m/odbc-query)
Acronym ODD [Rounds a number up to the nearest odd integer](https://support.microsoft.com/en-us/office/odd-function-deae64eb-e08a-4c88-8b40-6d0b42575c98)
Acronym ODDFPRICE [Returns the price per $100 face value of a security with an odd first period](https://support.microsoft.com/en-us/office/oddfprice-function-d7d664a8-34df-4233-8d2b-922bcf6a69e1)
Acronym ODDFYIELD [Returns the yield of a security with an odd first period](https://support.microsoft.com/en-us/office/oddfyield-function-66bc8b7b-6501-4c93-9ce3-2fd16220fe37)
Acronym ODDLPRICE [Returns the price per $100 face value of a security with an odd last period](https://support.microsoft.com/en-us/office/oddlprice-function-fb657749-d200-4902-afaf-ed5445027fc4)
Acronym ODDLYIELD [Returns the yield of a security with an odd last period](https://support.microsoft.com/en-us/office/oddlyield-function-c873d088-cf40-435f-8d41-c8232fee9238)
Acronym OFFSET [Returns a reference offset from a given reference](https://support.microsoft.com/en-us/office/offset-function-c8de19ae-dd79-4b9b-a14e-b4d906d11b66)
Acronym OleDb.DataSource [Power Query M: Returns a table of SQL tables and views from the OLE DB data source specified by the connection string.](https://docs.microsoft.com/en-us/powerquery-m/oledb-datasource)
Acronym OleDb.Query [Power Query M: Returns the result of running a native query on an OLE DB data source.](https://docs.microsoft.com/en-us/powerquery-m/oledb-query)
Acronym OR [Returns TRUE if any argument is TRUE](https://support.microsoft.com/en-us/office/or-function-7d17ad14-8700-4281-b308-00b131e22af0)
Acronym Oracle.Database [Power Query M: Returns a table with data relating to the tables in the specified Oracle Database.](https://docs.microsoft.com/en-us/powerquery-m/oracle-database)
Acronym Parquet.Document [Power Query M: Returns the contents of the Parquet document as a table.](https://docs.microsoft.com/en-us/powerquery-m/parquet-document)
Acronym Pdf.Tables [Power Query M: Returns any tables found in pdf.](https://docs.microsoft.com/en-us/powerquery-m/pdf-tables)
Acronym PDURATION [Returns the number of periods required by an investment to reach a specified value](https://support.microsoft.com/en-us/office/pduration-function-44f33460-5be5-4c90-b857-22308892adaf)
Acronym PEARSON [Returns the Pearson product moment correlation coefficient](https://support.microsoft.com/en-us/office/pearson-function-0c3e30fc-e5af-49c4-808a-3ef66e034c18)
Acronym Percentage.From [Power Query M: Returns a percentage value from the given value.](https://docs.microsoft.com/en-us/powerquery-m/percentage-from)
Acronym PERCENTILE [Returns the k-th percentile of values in a range](https://support.microsoft.com/en-us/office/percentile-function-91b43a53-543c-4708-93de-d626debdddca)
Acronym PERCENTILE.EXC [Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive](https://support.microsoft.com/en-us/office/percentile-exc-function-bbaa7204-e9e1-4010-85bf-c31dc5dce4ba)
Acronym PERCENTILE.INC [Returns the k-th percentile of values in a range](https://support.microsoft.com/en-us/office/percentile-inc-function-680f9539-45eb-410b-9a5e-c1355e5fe2ed)
Acronym PERCENTRANK [Returns the percentage rank of a value in a data set](https://support.microsoft.com/en-us/office/percentrank-function-f1b5836c-9619-4847-9fc9-080ec9024442)
Acronym PERCENTRANK.EXC [Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set](https://support.microsoft.com/en-us/office/percentrank-exc-function-d8afee96-b7e2-4a2f-8c01-8fcdedaa6314)
Acronym PERCENTRANK.INC [Returns the percentage rank of a value in a data set](https://support.microsoft.com/en-us/office/percentrank-inc-function-149592c9-00c0-49ba-86c1-c1f45b80463a)
Acronym PERMUT [Returns the number of permutations for a given number of objects](https://support.microsoft.com/en-us/office/permut-function-3bd1cb9a-2880-41ab-a197-f246a7a602d3)
Acronym PERMUTATIONA [Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects](https://support.microsoft.com/en-us/office/permutationa-function-6c7d7fdc-d657-44e6-aa19-2857b25cae4e)
Acronym PHI [Returns the value of the density function for a standard normal distribution](https://support.microsoft.com/en-us/office/phi-function-23e49bc6-a8e8-402d-98d3-9ded87f6295c)
Acronym PHONETIC [Extracts the phonetic (furigana) characters from a text string](https://support.microsoft.com/en-us/office/phonetic-function-9a329dac-0c0f-42f8-9a55-639086988554)
Acronym PI [Returns the value of pi](https://support.microsoft.com/en-us/office/pi-function-264199d0-a3ba-46b8-975a-c4a04608989b)
Acronym PMT [Returns the periodic payment for an annuity](https://support.microsoft.com/en-us/office/pmt-function-0214da64-9a63-4996-bc20-214433fa6441)
Acronym POISSON [Returns the Poisson distribution](https://support.microsoft.com/en-us/office/poisson-function-d81f7294-9d7c-4f75-bc23-80aa8624173a)
Acronym POISSON.DIST [Returns the Poisson distribution](https://support.microsoft.com/en-us/office/poisson-dist-function-8fe148ff-39a2-46cb-abf3-7772695d9636)
Acronym PostgreSQL.Database [Power Query M: Returns a table with data relating to the tables in the specified PostgreSQL Database.](https://docs.microsoft.com/en-us/powerquery-m/postgresql-database)
Acronym POWER [Returns the result of a number raised to a power](https://support.microsoft.com/en-us/office/power-function-d3f2908b-56f4-4c3f-895a-07fb519c362a)
Acronym PPMT [Returns the payment on the principal for an investment for a given period](https://support.microsoft.com/en-us/office/ppmt-function-c370d9e3-7749-4ca4-beea-b06c6ac95e1b)
Acronym Precision.Decimal [Power Query M: An optional parameter for the built-in arthimetic operators to specify decimal precision.](https://docs.microsoft.com/en-us/powerquery-m/precision-decimal)
Acronym Precision.Double [Power Query M: An optional parameter for the built-in arthimetic operators to specify double precision.](https://docs.microsoft.com/en-us/powerquery-m/precision-double)
Acronym PRICE [Returns the price per $100 face value of a security that pays periodic interest](https://support.microsoft.com/en-us/office/price-function-3ea9deac-8dfa-436f-a7c8-17ea02c21b0a)
Acronym PRICEDISC [Returns the price per $100 face value of a discounted security](https://support.microsoft.com/en-us/office/pricedisc-function-d06ad7c1-380e-4be7-9fd9-75e3079acfd3)
Acronym PRICEMAT [Returns the price per $100 face value of a security that pays interest at maturity](https://support.microsoft.com/en-us/office/pricemat-function-52c3b4da-bc7e-476a-989f-a95f675cae77)
Acronym PROB [Returns the probability that values in a range are between two limits](https://support.microsoft.com/en-us/office/prob-function-9ac30561-c81c-4259-8253-34f0a238fc49)
Acronym PRODUCT [Multiplies its arguments](https://support.microsoft.com/en-us/office/product-function-8e6b5b24-90ee-4650-aeec-80982a0512ce)
Acronym PROPER [Capitalizes the first letter in each word of a text value](https://support.microsoft.com/en-us/office/proper-function-52a5a283-e8b2-49be-8506-b2887b889f94)
Acronym PV [Returns the present value of an investment](https://support.microsoft.com/en-us/office/pv-function-23879d31-0e02-4321-be01-da16e8168cbd)
Acronym QUARTILE [Returns the quartile of a data set](https://support.microsoft.com/en-us/office/quartile-function-93cf8f62-60cd-4fdb-8a92-8451041e1a2a)
Acronym QUARTILE.EXC [Returns the quartile of the data set, based on percentile values from 0..1, exclusive](https://support.microsoft.com/en-us/office/quartile-exc-function-5a355b7a-840b-4a01-b0f1-f538c2864cad)
Acronym QUARTILE.INC [Returns the quartile of a data set](https://support.microsoft.com/en-us/office/quartile-inc-function-1bbacc80-5075-42f1-aed6-47d735c4819d)
Acronym QuoteStyle.Csv [Power Query M: Quote characters indicate the start of a quoted string. Nested quotes are indicated by two quote characters.](https://docs.microsoft.com/en-us/powerquery-m/quotestyle-csv)
Acronym QuoteStyle.None [Power Query M: Quote characters have no significance.](https://docs.microsoft.com/en-us/powerquery-m/quotestyle-none)
Acronym QUOTIENT [Returns the integer portion of a division](https://support.microsoft.com/en-us/office/quotient-function-9f7bf099-2a18-4282-8fa4-65290cc99dee)
Acronym RADIANS [Converts degrees to radians](https://support.microsoft.com/en-us/office/radians-function-ac409508-3d48-45f5-ac02-1497c92de5bf)
Acronym RAND [Returns a random number between 0 and 1](https://support.microsoft.com/en-us/office/rand-function-4cbfa695-8869-4788-8d90-021ea9f5be73)
Acronym RANDARRAY [Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values.](https://support.microsoft.com/en-us/office/randarray-function-21261e55-3bec-4885-86a6-8b0a47fd4d33)
Acronym RANDBETWEEN [Returns a random number between the numbers you specify](https://support.microsoft.com/en-us/office/randbetween-function-4cc7f0d1-87dc-4eb7-987f-a469ab381685)
Acronym RANK [Returns the rank of a number in a list of numbers](https://support.microsoft.com/en-us/office/rank-function-6a2fc49d-1831-4a03-9d8c-c279cf99f723)
Acronym RANK.AVG [Returns the rank of a number in a list of numbers](https://support.microsoft.com/en-us/office/rank-avg-function-bd406a6f-eb38-4d73-aa8e-6d1c3c72e83a)
Acronym RANK.EQ [Returns the rank of a number in a list of numbers](https://support.microsoft.com/en-us/office/rank-eq-function-284858ce-8ef6-450e-b662-26245be04a40)
Acronym RATE [Returns the interest rate per period of an annuity](https://support.microsoft.com/en-us/office/rate-function-9f665657-4a7e-4bb7-a030-83fc59e748ce)
Acronym RData.FromBinary [Power Query M: Returns a record of data frames from the RData file.](https://docs.microsoft.com/en-us/powerquery-m/rdata-frombinary)
Acronym RECEIVED [Returns the amount received at maturity for a fully invested security](https://support.microsoft.com/en-us/office/received-function-7a3f8b93-6611-4f81-8576-828312c9b5e5)
Acronym Record.AddField [Power Query M: Adds a field from a field name and value.](https://docs.microsoft.com/en-us/powerquery-m/record-addfield)
Acronym Record.Combine [Power Query M: Combines the records in a list.](https://docs.microsoft.com/en-us/powerquery-m/record-combine)
Acronym Record.Field [Power Query M: Returns the value of the given field. This function can be used to dynamically create field lookup syntax for a given record. In that way it is a dynamic verison of the record[field] syntax.](https://docs.microsoft.com/en-us/powerquery-m/record-field)
Acronym Record.FieldCount [Power Query M: Returns the number of fields in a record.](https://docs.microsoft.com/en-us/powerquery-m/record-fieldcount)
Acronym Record.FieldNames [Power Query M: Returns a list of field names in order of the record's fields.](https://docs.microsoft.com/en-us/powerquery-m/record-fieldnames)
Acronym Record.FieldOrDefault [Power Query M: Returns the value of a field from a record, or the default value if the field does not exist.](https://docs.microsoft.com/en-us/powerquery-m/record-fieldordefault)
Acronym Record.FieldValues [Power Query M: Returns a list of field values in order of the record's fields.](https://docs.microsoft.com/en-us/powerquery-m/record-fieldvalues)
Acronym Record.FromList [Power Query M: Returns a record given a list of field values and a set of fields.](https://docs.microsoft.com/en-us/powerquery-m/record-fromlist)
Acronym Record.FromTable [Power Query M: Returns a record from a table of records containing field names and values.](https://docs.microsoft.com/en-us/powerquery-m/record-fromtable)
Acronym Record.HasFields [Power Query M: Returns true if the field name or field names are present in a record.](https://docs.microsoft.com/en-us/powerquery-m/record-hasfields)
Acronym Record.RemoveFields [Power Query M: Returns a new record that reorders the given fields with respect to each other. Any fields not specified remain in their original locations.](https://docs.microsoft.com/en-us/powerquery-m/record-removefields)
Acronym Record.RenameFields [Power Query M: Returns a new record that renames the fields specified. The resultant fields will retain their original order. This function supports swapping and chaining field names. However, all target names plus remaining field names must constitute a unique set or an error will occur.](https://docs.microsoft.com/en-us/powerquery-m/record-renamefields)
Acronym Record.ReorderFields [Power Query M: Returns a new record that reorders fields relative to each other. Any fields not specified remain in their original locations. Requires two or more fields.](https://docs.microsoft.com/en-us/powerquery-m/record-reorderfields)
Acronym Record.SelectFields [Power Query M: Returns a new record that contains the fields selected from the input record. The original order of the fields is maintained.](https://docs.microsoft.com/en-us/powerquery-m/record-selectfields)
Acronym Record.ToList [Power Query M: Returns a list of values containing the field values of the input record.](https://docs.microsoft.com/en-us/powerquery-m/record-tolist)
Acronym Record.ToTable [Power Query M: Returns a table of records containing field names and values from an input record.](https://docs.microsoft.com/en-us/powerquery-m/record-totable)
Acronym Record.TransformFields [Power Query M: Transforms fields by applying transformOperations. For more more information about values supported by transformOperations, see Parameter Values.](https://docs.microsoft.com/en-us/powerquery-m/record-transformfields)
Acronym REGISTER.ID [Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered](https://support.microsoft.com/en-us/office/register-id-function-f8f0af0f-fd66-4704-a0f2-87b27b175b50)
Acronym RelativePosition.FromEnd [Power Query M: Indicates indexing should be done from the end of the input.](https://docs.microsoft.com/en-us/powerquery-m/relativeposition-fromend)
Acronym RelativePosition.FromStart [Power Query M: Indicates indexing should be done from the start of the input.](https://docs.microsoft.com/en-us/powerquery-m/relativeposition-fromstart)
Acronym REPLACE [Replaces characters within text](https://support.microsoft.com/en-us/office/replace-replaceb-functions-8d799074-2425-4a8a-84bc-82472868878a)
Acronym REPLACEB [Replaces characters within text](https://support.microsoft.com/en-us/office/replace-replaceb-functions-8d799074-2425-4a8a-84bc-82472868878a)
Acronym Replacer.ReplaceText [Power Query M: This function be provided to List.ReplaceValue or Table.ReplaceValue to do replace of text values in list and table values respectively.](https://docs.microsoft.com/en-us/powerquery-m/replacer-replacetext)
Acronym Replacer.ReplaceValue [Power Query M: This function be provided to List.ReplaceValue or Table.ReplaceValue to do replace values in list and table values respectively.](https://docs.microsoft.com/en-us/powerquery-m/replacer-replacevalue)
Acronym REPT [Repeats text a given number of times](https://support.microsoft.com/en-us/office/rept-function-04c4d778-e712-43b4-9c15-d656582bb061)
Acronym RIGHT [Returns the rightmost characters from a text value](https://support.microsoft.com/en-us/office/right-rightb-functions-240267ee-9afa-4639-a02b-f19e1786cf2f)
Acronym RIGHTB [Returns the rightmost characters from a text value](https://support.microsoft.com/en-us/office/right-rightb-functions-240267ee-9afa-4639-a02b-f19e1786cf2f)
Acronym ROMAN [Converts an arabic numeral to roman, as text](https://support.microsoft.com/en-us/office/roman-function-d6b0b99e-de46-4704-a518-b45a0f8b56f5)
Acronym ROUND [Rounds a number to a specified number of digits](https://support.microsoft.com/en-us/office/round-function-c018c5d8-40fb-4053-90b1-b3e7f61a213c)
Acronym ROUNDDOWN [Rounds a number down, toward zero](https://support.microsoft.com/en-us/office/rounddown-function-2ec94c73-241f-4b01-8c6f-17e6d7968f53)
Acronym RoundingMode.AwayFromZero [Power Query M: RoundingMode.AwayFromZero](https://docs.microsoft.com/en-us/powerquery-m/roundingmode-awayfromzero)
Acronym RoundingMode.Down [Power Query M: RoundingMode.Down](https://docs.microsoft.com/en-us/powerquery-m/roundingmode-down)
Acronym RoundingMode.ToEven [Power Query M: RoundingMode.ToEven](https://docs.microsoft.com/en-us/powerquery-m/roundingmode-toeven)
Acronym RoundingMode.TowardZero [Power Query M: RoundingMode.TowardZero](https://docs.microsoft.com/en-us/powerquery-m/roundingmode-towardzero)
Acronym RoundingMode.Up [Power Query M: RoundingMode.Up](https://docs.microsoft.com/en-us/powerquery-m/roundingmode-up)
Acronym ROUNDUP [Rounds a number up, away from zero](https://support.microsoft.com/en-us/office/roundup-function-f8bc9b23-e795-47db-8703-db171d0c42a7)
Acronym ROW [Returns the row number of a reference](https://support.microsoft.com/en-us/office/row-function-3a63b74a-c4d0-4093-b49a-e76eb49a6d8d)
Acronym RowExpression.Column [Power Query M: Returns an AST that represents access to a column within a row expression.](https://docs.microsoft.com/en-us/powerquery-m/rowexpression-column)
Acronym RowExpression.From [Power Query M: Returns the AST for the body of a function.](https://docs.microsoft.com/en-us/powerquery-m/rowexpression-from)
Acronym RowExpression.Row [Power Query M: An AST node representing the row in a row expression.](https://docs.microsoft.com/en-us/powerquery-m/rowexpression-row)
Acronym ROWS [Returns the number of rows in a reference](https://support.microsoft.com/en-us/office/rows-function-b592593e-3fc2-47f2-bec1-bda493811597)
Acronym RRI [Returns an equivalent interest rate for the growth of an investment](https://support.microsoft.com/en-us/office/rri-function-6f5822d8-7ef1-4233-944c-79e8172930f4)
Acronym RSQ [Returns the square of the Pearson product moment correlation coefficient](https://support.microsoft.com/en-us/office/rsq-function-d7161715-250d-4a01-b80d-a8364f2be08f)
Acronym RTD [Retrieves real-time data from a program that supports COM automation](https://support.microsoft.com/en-us/office/rtd-function-e0cc001a-56f0-470a-9b19-9455dc0eb593)
Acronym Salesforce.Data [Power Query M: Connects to the Salesforce Objects API and returns the set of available objects (i.e. Accounts).](https://docs.microsoft.com/en-us/powerquery-m/salesforce-data)
Acronym Salesforce.Reports [Power Query M: Connects to the Salesforce Reports API and returns the set of available reports.](https://docs.microsoft.com/en-us/powerquery-m/salesforce-reports)
Acronym SapBusinessWarehouse.Cubes [Power Query M: Returns the InfoCubes and queries in an SAP Business Warehouse system grouped by InfoArea.](https://docs.microsoft.com/en-us/powerquery-m/sapbusinesswarehouse-cubes)
Acronym SapBusinessWarehouseExecutionMod [Power Query M: 'DataStream flattening mode' option for MDX execution in SAP Business Warehouse.](https://docs.microsoft.com/en-us/powerquery-m/sapbusinesswarehouseexecutionmode.datastream)
Acronym SapBusinessWarehouseExecutionMod [Power Query M: 'bXML flattening mode' option for MDX execution in SAP Business Warehouse.](https://docs.microsoft.com/en-us/powerquery-m/sapbusinesswarehouseexecutionmode.basxml)
Acronym SapBusinessWarehouseExecutionMod [Power Query M: 'Gzip compressed bXML flattening mode' option for MDX execution in SAP Business Warehouse. Recommended for low latency or high volume queries.](https://docs.microsoft.com/en-us/powerquery-m/sapbusinesswarehouseexecutionmode.basxmlgzip)
Acronym SapHana.Database [Power Query M: Returns the packages in an SAP HANA database.](https://docs.microsoft.com/en-us/powerquery-m/saphana-database)
Acronym SapHanaDistribution.All [Power Query M: Returns the packages in an SAP HANA database.](https://docs.microsoft.com/en-us/powerquery-m/saphanadistribution-all)
Acronym SapHanaDistribution.Connection [Power Query M: 'Connection' distribution option for SAP HANA.](https://docs.microsoft.com/en-us/powerquery-m/saphanadistribution-connection)
Acronym SapHanaDistribution.Off [Power Query M: 'Off' distribution option for SAP HANA.](https://docs.microsoft.com/en-us/powerquery-m/saphanadistribution-off)
Acronym SapHanaDistribution.Statement [Power Query M: 'Statement' distribution option for SAP HANA.](https://docs.microsoft.com/en-us/powerquery-m/saphanadistribution-statement)
Acronym SapHanaRangeOperator.Equals [Power Query M: 'Equals' range operator for SAP HANA input parameters.](https://docs.microsoft.com/en-us/powerquery-m/saphanarangeoperator-equals)
Acronym SapHanaRangeOperator.GreaterThan [Power Query M: 'Greater than' range operator for SAP HANA input parameters.](https://docs.microsoft.com/en-us/powerquery-m/saphanarangeoperator-greaterthan)
Acronym SapHanaRangeOperator.GreaterThan [Power Query M: 'Greater than or equals' range operator for SAP HANA input parameters.](https://docs.microsoft.com/en-us/powerquery-m/saphanarangeoperator-greaterthanorequals)
Acronym SapHanaRangeOperator.LessThan [Power Query M: 'Less than' range operator for SAP HANA input parameters.](https://docs.microsoft.com/en-us/powerquery-m/saphanarangeoperator-lessthan)
Acronym SapHanaRangeOperator.LessThanOrE [Power Query M: 'Less than or equals' range operator for SAP HANA input parameters.](https://docs.microsoft.com/en-us/powerquery-m/saphanarangeoperator-lessthanorequals)
Acronym SapHanaRangeOperator.NotEquals [Power Query M: 'Not equals' range operator for SAP HANA input parameters.](https://docs.microsoft.com/en-us/powerquery-m/saphanarangeoperator-equals)
Acronym SEARCH [Finds one text value within another (not case-sensitive)](https://support.microsoft.com/en-us/office/search-searchb-functions-9ab04538-0e55-4719-a72e-b6f54513b495)
Acronym SEARCHB [Finds one text value within another (not case-sensitive)](https://support.microsoft.com/en-us/office/search-searchb-functions-9ab04538-0e55-4719-a72e-b6f54513b495)
Acronym SEC [Returns the secant of an angle](https://support.microsoft.com/en-us/office/sec-function-ff224717-9c87-4170-9b58-d069ced6d5f7)
Acronym SECH [Returns the hyperbolic secant of an angle](https://support.microsoft.com/en-us/office/sech-function-e05a789f-5ff7-4d7f-984a-5edb9b09556f)
Acronym SECOND [Converts a serial number to a second](https://support.microsoft.com/en-us/office/second-function-740d1cfc-553c-4099-b668-80eaa24e8af1)
Acronym SEQUENCE [Generates a list of sequential numbers in an array, such as 1, 2, 3, 4](https://support.microsoft.com/en-us/office/sequence-function-57467a98-57e0-4817-9f14-2eb78519ca90)
Acronym SERIESSUM [Returns the sum of a power series based on the formula](https://support.microsoft.com/en-us/office/seriessum-function-a3ab25b5-1093-4f5b-b084-96c49087f637)
Acronym SharePoint.Contents [Power Query M: Returns a table containing a row for each folder and document found at the SharePoint site url. Each row contains properties of the folder or file and a link to its content.](https://docs.microsoft.com/en-us/powerquery-m/sharepoint-contents)
Acronym SharePoint.Files [Power Query M: Returns a table containing a row for each document found at the SharePoint site url, and subfolders. Each row contains properties of the folder or file and a link to its content.](https://docs.microsoft.com/en-us/powerquery-m/sharepoint-files)
Acronym SharePoint.Tables [Power Query M: Returns a table containing the result of a SharePoint List as an OData feed.](https://docs.microsoft.com/en-us/powerquery-m/sharepoint-tables)
Acronym SHEET [Returns the sheet number of the referenced sheet](https://support.microsoft.com/en-us/office/sheet-function-44718b6f-8b87-47a1-a9d6-b701c06cff24)
Acronym SHEETS [Returns the number of sheets in a reference](https://support.microsoft.com/en-us/office/sheets-function-770515eb-e1e8-45ce-8066-b557e5e4b80b)
Acronym SIGN [Returns the sign of a number](https://support.microsoft.com/en-us/office/sign-function-109c932d-fcdc-4023-91f1-2dd0e916a1d8)
Acronym SIN [Returns the sine of the given angle](https://support.microsoft.com/en-us/office/sin-function-cf0e3432-8b9e-483c-bc55-a76651c95602)
Acronym Single.From [Power Query M: Returns a Single number value from the given value.](https://docs.microsoft.com/en-us/powerquery-m/single-from)
Acronym SINH [Returns the hyperbolic sine of a number](https://support.microsoft.com/en-us/office/sinh-function-1e4e8b9f-2b65-43fc-ab8a-0a37f4081fa7)
Acronym SKEW [Returns the skewness of a distribution](https://support.microsoft.com/en-us/office/skew-function-bdf49d86-b1ef-4804-a046-28eaea69c9fa)
Acronym SKEW.P [Returns the skewness of a distribution based on a population](https://support.microsoft.com/en-us/office/skew-p-function-76530a5c-99b9-48a1-8392-26632d542fcb)
Acronym SLN [Returns the straight-line depreciation of an asset for one period](https://support.microsoft.com/en-us/office/sln-function-cdb666e5-c1c6-40a7-806a-e695edc2f1c8)
Acronym SLOPE [Returns the slope of the linear regression line](https://support.microsoft.com/en-us/office/slope-function-11fb8f97-3117-4813-98aa-61d7e01276b9)
Acronym SMALL [Returns the k-th smallest value in a data set](https://support.microsoft.com/en-us/office/small-function-17da8222-7c82-42b2-961b-14c45384df07)
Acronym Soda.Feed [Power Query M: Returns the resulting table of a CSV file that can be accessed using the SODA 2.0 API. The URL must point to a valid SODA-compliant source that ends in a .csv extension.](https://docs.microsoft.com/en-us/powerquery-m/soda-feed)
Acronym SORT [Sorts the contents of a range or array](https://support.microsoft.com/en-us/office/sort-function-22f63bd0-ccc8-492f-953d-c20e8e44b86c)
Acronym SORTBY [Sorts the contents of a range or array based on the values in a corresponding range or array](https://support.microsoft.com/en-us/office/sortby-function-cd2d7a62-1b93-435c-b561-d6a35134f28f)
Acronym Splitter.SplitByNothing [Power Query M: Returns a function that does no splitting, returning its argument as a single element list.](https://docs.microsoft.com/en-us/powerquery-m/splitter-splitbynothing)
Acronym Splitter.SplitTextByAnyDelimiter [Power Query M: Returns a function that splits text by any supported delimiter.](https://docs.microsoft.com/en-us/powerquery-m/splitter-splittextbyanydelimiter)
Acronym Splitter.SplitTextByCharacterTra [Power Query M: Returns a function that splits text into a list of text according to a transition from one kind of character to another.](https://docs.microsoft.com/en-us/powerquery-m/splitter-splittextbycharactertransition)
Acronym Splitter.SplitTextByDelimiter [Power Query M: Returns a function that will split text according to a delimiter.](https://docs.microsoft.com/en-us/powerquery-m/splitter-splittextbydelimiter)
Acronym Splitter.SplitTextByEachDelimite [Power Query M: Returns a function that splits text by each delimiter in turn.](https://docs.microsoft.com/en-us/powerquery-m/splitter-splittextbyeachdelimiter)
Acronym Splitter.SplitTextByLengths [Power Query M: Returns a function that splits text according to the specified lengths.](https://docs.microsoft.com/en-us/powerquery-m/splitter-splittextbylengths)
Acronym Splitter.SplitTextByPositions [Power Query M: Returns a function that splits text according to the specified positions.](https://docs.microsoft.com/en-us/powerquery-m/splitter-splittextbypositions)
Acronym Splitter.SplitTextByRanges [Power Query M: Returns a function that splits text according to the specified ranges.](https://docs.microsoft.com/en-us/powerquery-m/splitter-splittextbyranges)
Acronym Splitter.SplitTextByRepeatedLeng [Power Query M: Returns a function that splits text into a list of text after the specified length repeatedly.](https://docs.microsoft.com/en-us/powerquery-m/splitter-splittextbyrepeatedlengths)
Acronym Splitter.SplitTextByWhitespace [Power Query M: Returns a function that splits text according to whitespace.](https://docs.microsoft.com/en-us/powerquery-m/splitter-splittextbywhitespace)
Acronym Sql.Database [Power Query M: Returns a table containing SQL tables located on a SQL Server instance database.](https://docs.microsoft.com/en-us/powerquery-m/sql-database)
Acronym Sql.Databases [Power Query M: Returns a table with references to databases located on a SQL Server instance. Returns a navigation table.](https://docs.microsoft.com/en-us/powerquery-m/sql-databases)
Acronym SqlExpression.SchemaFrom [Power Query M: SqlExpression.SchemaFrom](https://docs.microsoft.com/en-us/powerquery-m/sqlexpression-schemafrom)
Acronym SqlExpression.ToExpression [Power Query M: SqlExpression.ToExpression](https://docs.microsoft.com/en-us/powerquery-m/sqlexpression-toexpression)
Acronym SQRT [Returns a positive square root](https://support.microsoft.com/en-us/office/sqrt-function-654975c2-05c4-4831-9a24-2c65e4040fdf)
Acronym SQRTPI [Returns the square root of (number * pi)](https://support.microsoft.com/en-us/office/sqrtpi-function-1fb4e63f-9b51-46d6-ad68-b3e7a8b519b4)
Acronym STANDARDIZE [Returns a normalized value](https://support.microsoft.com/en-us/office/standardize-function-81d66554-2d54-40ec-ba83-6437108ee775)
Acronym STDEV [Estimates standard deviation based on a sample](https://support.microsoft.com/en-us/office/stdev-function-51fecaaa-231e-4bbb-9230-33650a72c9b0)
Acronym STDEV.P [Calculates standard deviation based on the entire population](https://support.microsoft.com/en-us/office/stdev-p-function-6e917c05-31a0-496f-ade7-4f4e7462f285)
Acronym STDEV.S [Estimates standard deviation based on a sample](https://support.microsoft.com/en-us/office/stdev-s-function-7d69cf97-0c1f-4acf-be27-f3e83904cc23)
Acronym STDEVA [Estimates standard deviation based on a sample, including numbers, text, and logical values](https://support.microsoft.com/en-us/office/stdeva-function-5ff38888-7ea5-48de-9a6d-11ed73b29e9d)
Acronym STDEVP [Calculates standard deviation based on the entire population](https://support.microsoft.com/en-us/office/stdevp-function-1f7c1c88-1bec-4422-8242-e9f7dc8bb195)
Acronym STDEVPA [Calculates standard deviation based on the entire population, including numbers, text, and logical values](https://support.microsoft.com/en-us/office/stdevpa-function-5578d4d6-455a-4308-9991-d405afe2c28c)
Acronym STEYX [Returns the standard error of the predicted y-value for each x in the regression](https://support.microsoft.com/en-us/office/steyx-function-6ce74b2c-449d-4a6e-b9ac-f9cef5ba48ab)
Acronym SUBSTITUTE [Substitutes new text for old text in a text string](https://support.microsoft.com/en-us/office/substitute-function-6434944e-a904-4336-a9b0-1e58df3bc332)
Acronym SUBTOTAL [Returns a subtotal in a list or database](https://support.microsoft.com/en-us/office/subtotal-function-7b027003-f060-4ade-9040-e478765b9939)
Acronym SUM [Adds its arguments](https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89)
Acronym SUMIF [Adds the cells specified by a given criteria](https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b)
Acronym SUMIFS [Adds the cells in a range that meet multiple criteria](https://support.microsoft.com/en-us/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b)
Acronym SUMPRODUCT [Returns the sum of the products of corresponding array components](https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e)
Acronym SUMSQ [Returns the sum of the squares of the arguments](https://support.microsoft.com/en-us/office/sumsq-function-e3313c02-51cc-4963-aae6-31442d9ec307)
Acronym SUMX2MY2 [Returns the sum of the difference of squares of corresponding values in two arrays](https://support.microsoft.com/en-us/office/sumx2my2-function-9e599cc5-5399-48e9-a5e0-e37812dfa3e9)
Acronym SUMX2PY2 [Returns the sum of the sum of squares of corresponding values in two arrays](https://support.microsoft.com/en-us/office/sumx2py2-function-826b60b4-0aa2-4e5e-81d2-be704d3d786f)
Acronym SUMXMY2 [Returns the sum of squares of differences of corresponding values in two arrays](https://support.microsoft.com/en-us/office/sumxmy2-function-9d144ac1-4d79-43de-b524-e2ecee23b299)
Acronym SWITCH [Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.](https://support.microsoft.com/en-us/office/switch-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e)
Acronym Sybase.Database [Power Query M: Returns a table with data relating to the tables in the specified Sybase Database.](https://docs.microsoft.com/en-us/powerquery-m/sybase-database)
Acronym SYD [Returns the sum-of-years' digits depreciation of an asset for a specified period](https://support.microsoft.com/en-us/office/syd-function-069f8106-b60b-4ca2-98e0-2a0f206bdb27)
Acronym T [Converts its arguments to text](https://support.microsoft.com/en-us/office/t-function-fb83aeec-45e7-4924-af95-53e073541228)
Acronym T.DIST [Returns the Percentage Points (probability) for the Student t-distribution](https://support.microsoft.com/en-us/office/t-dist-function-4329459f-ae91-48c2-bba8-1ead1c6c21b2)
Acronym T.DIST.2T [Returns the Percentage Points (probability) for the Student t-distribution](https://support.microsoft.com/en-us/office/t-dist-2t-function-198e9340-e360-4230-bd21-f52f22ff5c28)
Acronym T.DIST.RT [Returns the Student's t-distribution](https://support.microsoft.com/en-us/office/t-dist-rt-function-20a30020-86f9-4b35-af1f-7ef6ae683eda)
Acronym T.INV [Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom](https://support.microsoft.com/en-us/office/t-inv-function-2908272b-4e61-4942-9df9-a25fec9b0e2e)
Acronym T.INV.2T [Returns the inverse of the Student's t-distribution](https://support.microsoft.com/en-us/office/t-inv-2t-function-ce72ea19-ec6c-4be7-bed2-b9baf2264f17)
Acronym T.TEST [Returns the probability associated with a Student's t-test](https://support.microsoft.com/en-us/office/t-test-function-d4e08ec3-c545-485f-962e-276f7cbed055)
Acronym Table.AddColumn [Power Query M: Adds a column named newColumnName to a table.](https://docs.microsoft.com/en-us/powerquery-m/table-addcolumn)
Acronym Table.AddFuzzyClusterColumn [Power Query M: Adds a new column with representative values obtained by fuzzy grouping values of the specified column in the table.](https://docs.microsoft.com/en-us/powerquery-m/table-addfuzzyclustercolumn)
Acronym Table.AddIndexColumn [Power Query M: Returns a table with a new column with a specific name that, for each row, contains an index of the row in the table.](https://docs.microsoft.com/en-us/powerquery-m/table-addindexcolumn)
Acronym Table.AddJoinColumn [Power Query M: Performs a nested join between table1 and table2 from specific columns and produces the join result as a newColumnName column for each row of table1.](https://docs.microsoft.com/en-us/powerquery-m/table-addjoincolumn)
Acronym Table.AddKey [Power Query M: Add a key to table.](https://docs.microsoft.com/en-us/powerquery-m/table-addkey)
Acronym Table.AggregateTableColumn [Power Query M: Aggregates tables nested in a specific column into multiple columns containing aggregate values for those tables.](https://docs.microsoft.com/en-us/powerquery-m/table-aggregatetablecolumn)
Acronym Table.AlternateRows [Power Query M: Returns a table containing an alternating pattern of the rows from a table.](https://docs.microsoft.com/en-us/powerquery-m/table-alternaterows)
Acronym Table.Buffer [Power Query M: Buffers a table into memory, isolating it from external changes during evaluation.](https://docs.microsoft.com/en-us/powerquery-m/table-buffer)
Acronym Table.Column [Power Query M: Returns the values from a column in a table.](https://docs.microsoft.com/en-us/powerquery-m/table-column)
Acronym Table.ColumnCount [Power Query M: Returns the number of columns in a table.](https://docs.microsoft.com/en-us/powerquery-m/table-columncount)
Acronym Table.ColumnNames [Power Query M: Returns the names of columns from a table.](https://docs.microsoft.com/en-us/powerquery-m/table-columnnames)
Acronym Table.ColumnsOfType [Power Query M: Returns a list with the names of the columns that match the specified types.](https://docs.microsoft.com/en-us/powerquery-m/table-columnsoftype)
Acronym Table.Combine [Power Query M: Returns a table that is the result of merging a list of tables. The tables must all have the same row type structure.](https://docs.microsoft.com/en-us/powerquery-m/table-combine)
Acronym Table.CombineColumns [Power Query M: Table.CombineColumns merges columns using a combiner function to produce a new column. Table.CombineColumns is the inverse of Table.SplitColumns.](https://docs.microsoft.com/en-us/powerquery-m/table-combinecolumns)
Acronym Table.CombineColumnsToRecord [Power Query M: Combines the specified columns into a new record-valued column where each record has field names and values corresponding to the column names and values of the columns that were combined.](https://docs.microsoft.com/en-us/powerquery-m/table-combinecolumnstorecord)
Acronym Table.Contains [Power Query M: Determines whether the a record appears as a row in the table.](https://docs.microsoft.com/en-us/powerquery-m/table-contains)
Acronym Table.ContainsAll [Power Query M: Determines whether all of the specified records appear as rows in the table.](https://docs.microsoft.com/en-us/powerquery-m/table-containsall)
Acronym Table.ContainsAny [Power Query M: Determines whether any of the specified records appear as rows in the table.](https://docs.microsoft.com/en-us/powerquery-m/table-containsany)
Acronym Table.DemoteHeaders [Power Query M: Demotes the header row down into the first row of a table.](https://docs.microsoft.com/en-us/powerquery-m/table-demoteheaders)
Acronym Table.Distinct [Power Query M: Removes duplicate rows from a table, ensuring that all remaining rows are distinct.](https://docs.microsoft.com/en-us/powerquery-m/table-distinct)
Acronym Table.DuplicateColumn [Power Query M: Duplicates a column with the specified name. Values and type are copied from the source column.](https://docs.microsoft.com/en-us/powerquery-m/table-duplicatecolumn)
Acronym Table.ExpandListColumn [Power Query M: Given a column of lists in a table, create a copy of a row for each value in its list.](https://docs.microsoft.com/en-us/powerquery-m/table-expandlistcolumn)
Acronym Table.ExpandRecordColumn [Power Query M: Expands a column of records into columns with each of the values.](https://docs.microsoft.com/en-us/powerquery-m/table-expandrecordcolumn)
Acronym Table.ExpandTableColumn [Power Query M: Expands a column of records or a column of tables into multiple columns in the containing table.](https://docs.microsoft.com/en-us/powerquery-m/table-expandtablecolumn)
Acronym Table.FillDown [Power Query M: Replaces null values in the specified column or columns of the table with the most recent non-null value in the column.](https://docs.microsoft.com/en-us/powerquery-m/table-filldown)
Acronym Table.FillUp [Power Query M: Returns a table from the table specified where the value of the next cell is propagated to the null values cells above in the column specified.](https://docs.microsoft.com/en-us/powerquery-m/table-fillup)
Acronym Table.FilterWithDataTable [Power Query M: No Description Provided. Click here to go to the documentation page.](https://docs.microsoft.com/en-us/powerquery-m/table-filterwithdatatable)
Acronym Table.FindText [Power Query M: Returns a table containing only the rows that have the specified text within one of their cells or any part thereof.](https://docs.microsoft.com/en-us/powerquery-m/table-findtext)
Acronym Table.First [Power Query M: Returns the first row from a table.](https://docs.microsoft.com/en-us/powerquery-m/table-first)
Acronym Table.FirstN [Power Query M: Returns the first row(s) of a table, depending on the countOrCondition parameter.](https://docs.microsoft.com/en-us/powerquery-m/table-firstn)
Acronym Table.FirstValue [Power Query M: Returns the first column of the first row of the table or a specified default value.](https://docs.microsoft.com/en-us/powerquery-m/table-firstvalue)
Acronym Table.FromColumns [Power Query M: Returns a table from a list containing nested lists with the column names and values.](https://docs.microsoft.com/en-us/powerquery-m/table-fromcolumns)
Acronym Table.FromList [Power Query M: Converts a list into a table by applying the specified splitting function to each item in the list.](https://docs.microsoft.com/en-us/powerquery-m/table-fromlist)
Acronym Table.FromPartitions [Power Query M: Returns a table that is the result of combining a set of partitioned tables into new columns. The type of the column can optionally be specified, the default is any.](https://docs.microsoft.com/en-us/powerquery-m/table-frompartitions)
Acronym Table.FromRecords [Power Query M: Returns a table from a list of records.](https://docs.microsoft.com/en-us/powerquery-m/table-fromrecords)
Acronym Table.FromRows [Power Query M: Creates a table from the list where each element of the list is a list that contains the column values for a single row.](https://docs.microsoft.com/en-us/powerquery-m/table-fromrows)
Acronym Table.FromValue [Power Query M: Returns a table with a column containing the provided value or list of values.](https://docs.microsoft.com/en-us/powerquery-m/table-fromvalue)
Acronym Table.FuzzyGroup [Power Query M: Groups the rows of a table by fuzzily matching values in the specified column for each row.](https://docs.microsoft.com/en-us/powerquery-m/table-fuzzygroup)
Acronym Table.FuzzyJoin [Power Query M: Joins the rows from the two tables that fuzzy match based on the given keys.](https://docs.microsoft.com/en-us/powerquery-m/table-fuzzyjoin)
Acronym Table.FuzzyNestedJoin [Power Query M: Performs a fuzzy join between tables on supplied columns and produces the join result in a new column.](https://docs.microsoft.com/en-us/powerquery-m/table-fuzzynestedjoin)
Acronym Table.Group [Power Query M: Groups table rows by the values of key columns for each row.](https://docs.microsoft.com/en-us/powerquery-m/table-group)
Acronym Table.HasColumns [Power Query M: Returns true if a table has the specified column or columns.](https://docs.microsoft.com/en-us/powerquery-m/table-hascolumns)
Acronym Table.InsertRows [Power Query M: Returns a table with the list of rows inserted into the table at an index. Each row to insert must match the row type of the table..](https://docs.microsoft.com/en-us/powerquery-m/table-insertrows)
Acronym Table.IsDistinct [Power Query M: Determines whether a table contains only distinct rows.](https://docs.microsoft.com/en-us/powerquery-m/table-isdistinct)
Acronym Table.IsEmpty [Power Query M: Returns true if the table does not contain any rows.](https://docs.microsoft.com/en-us/powerquery-m/table-isempty)
Acronym Table.Join [Power Query M: Joins the rows of table1 with the rows of table2 based on the equality of the values of the key columns selected by table1, key1 and table2, key2.](https://docs.microsoft.com/en-us/powerquery-m/table-join)
Acronym Table.Keys [Power Query M: Returns a list of key column names from a table.](https://docs.microsoft.com/en-us/powerquery-m/table-keys)
Acronym Table.Last [Power Query M: Returns the last row of a table.](https://docs.microsoft.com/en-us/powerquery-m/table-last)
Acronym Table.LastN [Power Query M: Returns the last row(s) from a table, depending on the countOrCondition parameter.](https://docs.microsoft.com/en-us/powerquery-m/table-lastn)
Acronym Table.MatchesAllRows [Power Query M: Returns true if all of the rows in a table meet a condition.](https://docs.microsoft.com/en-us/powerquery-m/table-matchesallrows)
Acronym Table.MatchesAnyRows [Power Query M: Returns true if any of the rows in a table meet a condition.](https://docs.microsoft.com/en-us/powerquery-m/table-matchesanyrows)
Acronym Table.Max [Power Query M: Returns the largest row or rows from a table using a comparisonCriteria.](https://docs.microsoft.com/en-us/powerquery-m/table-max)
Acronym Table.MaxN [Power Query M: Returns the largest N rows from a table. After the rows are sorted, the countOrCondition parameter must be specified to further filter the result.](https://docs.microsoft.com/en-us/powerquery-m/table-maxn)
Acronym Table.Min [Power Query M: Returns the smallest row or rows from a table using a comparisonCriteria.](https://docs.microsoft.com/en-us/powerquery-m/table-min)
Acronym Table.MinN [Power Query M: Returns the smallest N rows in the given table. After the rows are sorted, the countOrCondition parameter must be specified to further filter the result.](https://docs.microsoft.com/en-us/powerquery-m/table-minn)
Acronym Table.NestedJoin [Power Query M: Joins the rows of the tables based on the equality of the keys. The results are entered into a new column.](https://docs.microsoft.com/en-us/powerquery-m/table-nestedjoin)
Acronym Table.Partition [Power Query M: Partitions the table into a list of groups number of tables, based on the value of the column of each row and a hash function. The hash function is applied to the value of the column of a row to obtain a hash value for the row. The hash value modulo groups determines in which of the returned tables the row will be placed.](https://docs.microsoft.com/en-us/powerquery-m/table-partition)
Acronym Table.PartitionValues [Power Query M: Returns information about how a table is partitioned.](https://docs.microsoft.com/en-us/powerquery-m/table-partitionvalues)
Acronym Table.Pivot [Power Query M: Given a table and attribute column containing pivotValues, creates new columns for each of the pivot values and assigns them values from the valueColumn. An optional aggregationFunction can be provided to handle multiple occurrence of the same key value in the attribute column.](https://docs.microsoft.com/en-us/powerquery-m/table-pivot)
Acronym Table.PositionOf [Power Query M: Determines the position or positions of a row within a table.](https://docs.microsoft.com/en-us/powerquery-m/table-positionof)
Acronym Table.PositionOfAny [Power Query M: Determines the position or positions of any of the specified rows within the table.](https://docs.microsoft.com/en-us/powerquery-m/table-positionofany)
Acronym Table.PrefixColumns [Power Query M: Returns a table where the columns have all been prefixed with a text value.](https://docs.microsoft.com/en-us/powerquery-m/table-prefixcolumns)
Acronym Table.Profile [Power Query M: Returns a profile of the columns of a table.](https://docs.microsoft.com/en-us/powerquery-m/table-profile)
Acronym Table.PromoteHeaders [Power Query M: Promotes the first row of the table into its header or column names.](https://docs.microsoft.com/en-us/powerquery-m/table-promoteheaders)
Acronym Table.Range [Power Query M: Returns the specified number of rows from a table starting at an offset.](https://docs.microsoft.com/en-us/powerquery-m/table-range)
Acronym Table.RemoveColumns [Power Query M: Returns a table without a specific column or columns.](https://docs.microsoft.com/en-us/powerquery-m/table-removecolumns)
Acronym Table.RemoveFirstN [Power Query M: Returns a table with the specified number of rows removed from the table starting at the first row. The number of rows removed depends on the optional countOrCondition parameter.](https://docs.microsoft.com/en-us/powerquery-m/table-removefirstn)
Acronym Table.RemoveLastN [Power Query M: Returns a table with the specified number of rows removed from the table starting at the last row. The number of rows removed depends on the optional countOrCondition parameter.](https://docs.microsoft.com/en-us/powerquery-m/table-removelastn)
Acronym Table.RemoveMatchingRows [Power Query M: Removes all occurrences of rows from a table.](https://docs.microsoft.com/en-us/powerquery-m/table-removematchingrows)
Acronym Table.RemoveRows [Power Query M: Returns a table with the specified number of rows removed from the table starting at an offset.](https://docs.microsoft.com/en-us/powerquery-m/table-removerows)
Acronym Table.RemoveRowsWithErrors [Power Query M: Returns a table with all rows removed from the table that contain an error in at least one of the cells in a row.](https://docs.microsoft.com/en-us/powerquery-m/table-removerowswitherrors)
Acronym Table.RenameColumns [Power Query M: Returns a table with the columns renamed as specified.](https://docs.microsoft.com/en-us/powerquery-m/table-renamecolumns)
Acronym Table.ReorderColumns [Power Query M: Returns a table with specific columns in an order relative to one another.](https://docs.microsoft.com/en-us/powerquery-m/table-reordercolumns)
Acronym Table.Repeat [Power Query M: Returns a table containing the rows of the table repeated the count number of times.](https://docs.microsoft.com/en-us/powerquery-m/table-repeat)
Acronym Table.ReplaceErrorValues [Power Query M: Replaces the error values in the specified columns with the corresponding specified value.](https://docs.microsoft.com/en-us/powerquery-m/table-replaceerrorvalues)
Acronym Table.ReplaceKeys [Power Query M: Returns a new table with new key information set in the keys argument.](https://docs.microsoft.com/en-us/powerquery-m/table-replacekeys)
Acronym Table.ReplaceMatchingRows [Power Query M: Replaces specific rows from a table with the new rows.](https://docs.microsoft.com/en-us/powerquery-m/table-replacematchingrows)
Acronym Table.ReplaceRelationshipIdentit [Power Query M: No Description Provided. Click here to go to the documentation page.](https://docs.microsoft.com/en-us/powerquery-m/table-replacerelationshipidentity)
Acronym Table.ReplaceRows [Power Query M: Returns a table where the rows beginning at an offset and continuing for count are replaced with the provided rows.](https://docs.microsoft.com/en-us/powerquery-m/table-replacerows)
Acronym Table.ReplaceValue [Power Query M: Replaces oldValue with newValue in specific columns of a table, using the provided replacer function, such as text.Replace or Value.Replace.](https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue)
Acronym Table.ReverseRows [Power Query M: Returns a table with the rows in reverse order.](https://docs.microsoft.com/en-us/powerquery-m/table-reverserows)
Acronym Table.RowCount [Power Query M: Returns the number of rows in a table.](https://docs.microsoft.com/en-us/powerquery-m/table-rowcount)
Acronym Table.Schema [Power Query M: Returns a table containing a description of the columns (i.e. the schema) of the specified table.](https://docs.microsoft.com/en-us/powerquery-m/table-schema)
Acronym Table.SelectColumns [Power Query M: Returns a table that contains only specific columns.](https://docs.microsoft.com/en-us/powerquery-m/table-selectcolumns)
Acronym Table.SelectRows [Power Query M: Returns a table containing only the rows that match a condition.](https://docs.microsoft.com/en-us/powerquery-m/table-selectrows)
Acronym Table.SelectRowsWithErrors [Power Query M: Returns a table with only the rows from table that contain an error in at least one of the cells in a row.](https://docs.microsoft.com/en-us/powerquery-m/table-selectrowswitherrors)
Acronym Table.SingleRow [Power Query M: Returns a single row from a table.](https://docs.microsoft.com/en-us/powerquery-m/table-singlerow)
Acronym Table.Skip [Power Query M: Returns a table that does not contain the first row or rows of the table.](https://docs.microsoft.com/en-us/powerquery-m/table-skip)
Acronym Table.Sort [Power Query M: Sorts the rows in a table using a comparisonCriteria or a default ordering if one is not specified.](https://docs.microsoft.com/en-us/powerquery-m/table-sort)
Acronym Table.Split [Power Query M: Splits the specified table into a list of tables using the specified page size.](https://docs.microsoft.com/en-us/powerquery-m/table-split)
Acronym Table.SplitColumn [Power Query M: Returns a new set of columns from a single column applying a splitter function to each value.](https://docs.microsoft.com/en-us/powerquery-m/table-splitcolumn)
Acronym Table.ToColumns [Power Query M: Returns a list of nested lists each representing a column of values in the input table.](https://docs.microsoft.com/en-us/powerquery-m/table-tocolumns)
Acronym Table.ToList [Power Query M: Returns a table into a list by applying the specified combining function to each row of values in a table.](https://docs.microsoft.com/en-us/powerquery-m/table-tolist)
Acronym Table.ToRecords [Power Query M: Returns a list of records from an input table.](https://docs.microsoft.com/en-us/powerquery-m/table-torecords)
Acronym Table.ToRows [Power Query M: Returns a nested list of row values from an input table.](https://docs.microsoft.com/en-us/powerquery-m/table-torows)
Acronym Table.TransformColumnNames [Power Query M: Transforms column names by using the given function.](https://docs.microsoft.com/en-us/powerquery-m/table-transformcolumnnames)
Acronym Table.TransformColumns [Power Query M: Transforms columns from a table using a function.](https://docs.microsoft.com/en-us/powerquery-m/table-transformcolumns)
Acronym Table.TransformColumnTypes [Power Query M: Transforms the column types from a table using a type.](https://docs.microsoft.com/en-us/powerquery-m/table-transformcolumntypes)
Acronym Table.TransformRows [Power Query M: Transforms the rows from a table using a transform function.](https://docs.microsoft.com/en-us/powerquery-m/table-transformrows)
Acronym Table.Transpose [Power Query M: Returns a table with columns converted to rows and rows converted to columns from the input table.](https://docs.microsoft.com/en-us/powerquery-m/table-transpose)
Acronym Table.Unpivot [Power Query M: Given a list of table columns, transforms those columns into attribute-value pairs.](https://docs.microsoft.com/en-us/powerquery-m/table-unpivot)
Acronym Table.UnpivotOtherColumns [Power Query M: Translates all columns other than a specified set into attribute-value pairs, combined with the rest of the values in each row.](https://docs.microsoft.com/en-us/powerquery-m/table-unpivotothercolumns)
Acronym Table.View [Power Query M: Creates or extends a table with user-defined handlers for query and action operations.](https://docs.microsoft.com/en-us/powerquery-m/table-view)
Acronym Table.ViewFunction [Power Query M: Creates a function that can be intercepted by a handler defined on a view (via Table.View).](https://docs.microsoft.com/en-us/powerquery-m/table-viewfunction)
Acronym Tables.GetRelationships [Power Query M: Returns the relationships among a set of tables.](https://docs.microsoft.com/en-us/powerquery-m/tables-getrelationships)
Acronym TAN [Returns the tangent of a number](https://support.microsoft.com/en-us/office/tan-function-08851a40-179f-4052-b789-d7f699447401)
Acronym TANH [Returns the hyperbolic tangent of a number](https://support.microsoft.com/en-us/office/tanh-function-017222f0-a0c3-4f69-9787-b3202295dc6c)
Acronym TBILLEQ [Returns the bond-equivalent yield for a Treasury bill](https://support.microsoft.com/en-us/office/tbilleq-function-2ab72d90-9b4d-4efe-9fc2-0f81f2c19c8c)
Acronym TBILLPRICE [Returns the price per $100 face value for a Treasury bill](https://support.microsoft.com/en-us/office/tbillprice-function-eacca992-c29d-425a-9eb8-0513fe6035a2)
Acronym TBILLYIELD [Returns the yield for a Treasury bill](https://support.microsoft.com/en-us/office/tbillyield-function-6d381232-f4b0-4cd5-8e97-45b9c03468ba)
Acronym TDIST [Returns the Student's t-distribution](https://support.microsoft.com/en-us/office/tdist-function-630a7695-4021-4853-9468-4a1f9dcdd192)
Acronym Teradata.Database [Power Query M: Returns a table with data relating to the tables in the specified Teradata Database.](https://docs.microsoft.com/en-us/powerquery-m/teradata-database)
Acronym TEXT [Formats a number and converts it to text](https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c)
Acronym Text.AfterDelimiter [Power Query M: Returns the portion of text after the specified delimiter.](https://docs.microsoft.com/en-us/powerquery-m/text-afterdelimiter)
Acronym Text.At [Power Query M: Returns a character starting at a zero-based offset.](https://docs.microsoft.com/en-us/powerquery-m/text-at)
Acronym Text.BeforeDelimiter [Power Query M: Returns the portion of text before the specified delimiter.](https://docs.microsoft.com/en-us/powerquery-m/text-beforedelimiter)
Acronym Text.BetweenDelimiters [Power Query M: Returns the portion of text between the specified startDelimiter and endDelimiter.](https://docs.microsoft.com/en-us/powerquery-m/text-betweendelimiters)
Acronym Text.Clean [Power Query M: Returns the original text value with non-printable characters removed.](https://docs.microsoft.com/en-us/powerquery-m/text-clean)
Acronym Text.Combine [Power Query M: Returns a text value that is the result of joining all text values with each value separated by a separator.](https://docs.microsoft.com/en-us/powerquery-m/text-combine)
Acronym Text.Contains [Power Query M: Returns true if a text value substring was found within a text value string; otherwise, false.](https://docs.microsoft.com/en-us/powerquery-m/text-contains)
Acronym Text.End [Power Query M: Returns the number of characters from the end of a text value.](https://docs.microsoft.com/en-us/powerquery-m/text-end)
Acronym Text.EndsWith [Power Query M: Returns a logical value indicating whether a text value substring was found at the end of a string.](https://docs.microsoft.com/en-us/powerquery-m/text-endswith)
Acronym Text.From [Power Query M: Returns the text representation of a number, date, time, datetime, datetimezone, logical, duration or binary value. If a value is null, Text.From returns null. The optional culture parameter is used to format the text value according to the given culture.](https://docs.microsoft.com/en-us/powerquery-m/text-from)
Acronym Text.FromBinary [Power Query M: Decodes data from a binary value in to a text value using an encoding.](https://docs.microsoft.com/en-us/powerquery-m/text-frombinary)
Acronym Text.InferNumberType [Power Query M: Infers granular number type (Int64.Type, Double.Type, etc.) of text using culture.](https://docs.microsoft.com/en-us/powerquery-m/text-infernumbertype)
Acronym Text.Insert [Power Query M: Returns a text value with newValue inserted into a text value starting at a zero-based offset.](https://docs.microsoft.com/en-us/powerquery-m/text-insert)
Acronym Text.Length [Power Query M: Returns the number of characters in a text value.](https://docs.microsoft.com/en-us/powerquery-m/text-length)
Acronym Text.Lower [Power Query M: Returns the lowercase of a text value.](https://docs.microsoft.com/en-us/powerquery-m/text-lower)
Acronym Text.Middle [Power Query M: Returns the substring up to a specific length.](https://docs.microsoft.com/en-us/powerquery-m/text-middle)
Acronym Text.NewGuid [Power Query M: Returns a Guid value as a text value.](https://docs.microsoft.com/en-us/powerquery-m/text-newguid)
Acronym Text.PadEnd [Power Query M: Returns a text value padded at the end with pad to make it at least length characters.](https://docs.microsoft.com/en-us/powerquery-m/text-padend)
Acronym Text.PadStart [Power Query M: Returns a text value padded at the beginning with pad to make it at least length characters. If pad is not specified, whitespace is used as pad.](https://docs.microsoft.com/en-us/powerquery-m/text-padstart)
Acronym Text.PositionOf [Power Query M: Returns the first occurrence of substring in a string and returns its position starting at startOffset.](https://docs.microsoft.com/en-us/powerquery-m/text-positionof)
Acronym Text.PositionOfAny [Power Query M: Returns the first occurrence of a text value in list and returns its position starting at startOffset.](https://docs.microsoft.com/en-us/powerquery-m/text-positionofany)
Acronym Text.Proper [Power Query M: Returns a text value with first letters of all words converted to uppercase.](https://docs.microsoft.com/en-us/powerquery-m/text-proper)
Acronym Text.Range [Power Query M: Returns a number of characters from a text value starting at a zero-based offset and for count number of characters.](https://docs.microsoft.com/en-us/powerquery-m/text-range)
Acronym Text.Remove [Power Query M: Removes all occurrences of a character or list of characters from a text value. The removeChars parameter can be a character value or a list of character values.](https://docs.microsoft.com/en-us/powerquery-m/text-remove)
Acronym Text.RemoveRange [Power Query M: Removes count characters at a zero-based offset from a text value.](https://docs.microsoft.com/en-us/powerquery-m/text-removerange)
Acronym Text.Repeat [Power Query M: Returns a text value composed of the input text value repeated a number of times.](https://docs.microsoft.com/en-us/powerquery-m/text-repeat)
Acronym Text.Replace [Power Query M: Replaces all occurrences of a substring with a new text value.](https://docs.microsoft.com/en-us/powerquery-m/text-replace)
Acronym Text.ReplaceRange [Power Query M: Replaces length characters in a text value starting at a zero-based offset with the new text value.](https://docs.microsoft.com/en-us/powerquery-m/text-replacerange)
Acronym Text.Reverse [Power Query M: Reverses the provided text.](https://docs.microsoft.com/en-us/powerquery-m/text-reverse)
Acronym Text.Select [Power Query M: Selects all occurrences of the given character or list of characters from the input text value.](https://docs.microsoft.com/en-us/powerquery-m/text-select)
Acronym Text.Split [Power Query M: Returns a list containing parts of a text value that are delimited by a separator text value.](https://docs.microsoft.com/en-us/powerquery-m/text-split)
Acronym Text.SplitAny [Power Query M: Returns a list containing parts of a text value that are delimited by any separator text values.](https://docs.microsoft.com/en-us/powerquery-m/text-splitany)
Acronym Text.Start [Power Query M: Returns the count of characters from the start of a text value.](https://docs.microsoft.com/en-us/powerquery-m/text-start)
Acronym Text.StartsWith [Power Query M: Returns a logical value indicating whether a text value substring was found at the beginning of a string.](https://docs.microsoft.com/en-us/powerquery-m/text-startswith)
Acronym Text.ToBinary [Power Query M: Encodes a text value into binary value using an encoding.](https://docs.microsoft.com/en-us/powerquery-m/text-tobinary)
Acronym Text.ToList [Power Query M: Returns a list of characters from a text value.](https://docs.microsoft.com/en-us/powerquery-m/text-tolist)
Acronym Text.Trim [Power Query M: Removes any occurrences of characters in trimChars from text.](https://docs.microsoft.com/en-us/powerquery-m/text-trim)
Acronym Text.TrimEnd [Power Query M: Removes any occurrences of the characters specified in trimChars from the end of the original text value.](https://docs.microsoft.com/en-us/powerquery-m/text-trimend)
Acronym Text.TrimStart [Power Query M: Removes any occurrences of the characters in trimChars from the start of the original text value.](https://docs.microsoft.com/en-us/powerquery-m/text-trimstart)
Acronym Text.Upper [Power Query M: Returns the uppercase of a text value.](https://docs.microsoft.com/en-us/powerquery-m/text-upper)
Acronym TextEncoding.Ascii [Power Query M: Use to choose the ASCII binary form.](https://docs.microsoft.com/en-us/powerquery-m/textencoding-ascii)
Acronym TextEncoding.BigEndianUnicode [Power Query M: Use to choose the UTF16 big endian binary form.](https://docs.microsoft.com/en-us/powerquery-m/textencoding-bigendianunicode)
Acronym TextEncoding.Unicode [Power Query M: Use to choose the UTF16 little endian binary form.](https://docs.microsoft.com/en-us/powerquery-m/textencoding-unicode)
Acronym TextEncoding.Utf16 [Power Query M: Use to choose the UTF16 little endian binary form.](https://docs.microsoft.com/en-us/powerquery-m/textencoding-utf16)
Acronym TextEncoding.Utf8 [Power Query M: Use to choose the UTF8 binary form.](https://docs.microsoft.com/en-us/powerquery-m/textencoding-utf8)
Acronym TextEncoding.Windows [Power Query M: Use to choose the Windows binary form.](https://docs.microsoft.com/en-us/powerquery-m/textencoding-windows)
Acronym TEXTJOIN [Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.](https://support.microsoft.com/en-us/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c)
Acronym TIME [Returns the serial number of a particular time](https://support.microsoft.com/en-us/office/time-function-9a5aff99-8f7d-4611-845e-747d0b8d5457)
Acronym Time.EndOfHour [Power Query M: Returns a DateTime value from the end of the hour.](https://docs.microsoft.com/en-us/powerquery-m/time-endofhour)
Acronym Time.From [Power Query M: Returns a time value from a value.](https://docs.microsoft.com/en-us/powerquery-m/time-from)
Acronym Time.FromText [Power Query M: Returns a Time value from a set of date formats.](https://docs.microsoft.com/en-us/powerquery-m/time-fromtext)
Acronym Time.Hour [Power Query M: Returns an hour value from a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/time-hour)
Acronym Time.Minute [Power Query M: Returns a minute value from a DateTime value.](https://docs.microsoft.com/en-us/powerquery-m/time-minute)
Acronym Time.Second [Power Query M: Returns a second value from a DateTime value](https://docs.microsoft.com/en-us/powerquery-m/time-second)
Acronym Time.StartOfHour [Power Query M: Returns the first value of the hour from a time value.](https://docs.microsoft.com/en-us/powerquery-m/time-startofhour)
Acronym Time.ToRecord [Power Query M: Returns a record containing parts of a Date value.](https://docs.microsoft.com/en-us/powerquery-m/time-torecord)
Acronym Time.ToText [Power Query M: Returns a text value from a Time value.](https://docs.microsoft.com/en-us/powerquery-m/time-totext)
Acronym TIMEVALUE [Converts a time in the form of text to a serial number](https://support.microsoft.com/en-us/office/timevalue-function-0b615c12-33d8-4431-bf3d-f3eb6d186645)
Acronym TINV [Returns the inverse of the Student's t-distribution](https://support.microsoft.com/en-us/office/tinv-function-a7c85b9d-90f5-41fe-9ca5-1cd2f3e1ed7c)
Acronym TODAY [Returns the serial number of today's date](https://support.microsoft.com/en-us/office/today-function-5eb3078d-a82c-4736-8930-2f51a028fdd9)
Acronym TraceLevel.Critical [Power Query M: Returns 1, the value for Critical trace level.](https://docs.microsoft.com/en-us/powerquery-m/tracelevel-critical)
Acronym TraceLevel.Error [Power Query M: Returns 2, the value for Error trace level.](https://docs.microsoft.com/en-us/powerquery-m/tracelevel-error)
Acronym TraceLevel.Information [Power Query M: Returns 4, the value for Information trace level.](https://docs.microsoft.com/en-us/powerquery-m/tracelevel-information)
Acronym TraceLevel.Verbose [Power Query M: Returns 5, the value for Verbose trace level.](https://docs.microsoft.com/en-us/powerquery-m/tracelevel-verbose)
Acronym TraceLevel.Warning [Power Query M: Returns 3, the value for Warning trace level.](https://docs.microsoft.com/en-us/powerquery-m/tracelevel-warning)
Acronym TRANSPOSE [Returns the transpose of an array](https://support.microsoft.com/en-us/office/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027)
Acronym TREND [Returns values along a linear trend](https://support.microsoft.com/en-us/office/trend-function-e2f135f0-8827-4096-9873-9a7cf7b51ef1)
Acronym TRIM [Removes spaces from text](https://support.microsoft.com/en-us/office/trim-function-410388fa-c5df-49c6-b16c-9e5630b479f9)
Acronym TRIMMEAN [Returns the mean of the interior of a data set](https://support.microsoft.com/en-us/office/trimmean-function-d90c9878-a119-4746-88fa-63d988f511d3)
Acronym TRUE [Returns the logical value TRUE](https://support.microsoft.com/en-us/office/true-function-7652c6e3-8987-48d0-97cd-ef223246b3fb)
Acronym TRUNC [Truncates a number to an integer](https://support.microsoft.com/en-us/office/trunc-function-8b86a64c-3127-43db-ba14-aa5ceb292721)
Acronym TTEST [Returns the probability associated with a Student's t-test](https://support.microsoft.com/en-us/office/ttest-function-1696ffc1-4811-40fd-9d13-a0eaad83c7ae)
Acronym TYPE [Returns a number indicating the data type of a value](https://support.microsoft.com/en-us/office/type-function-45b4e688-4bc3-48b3-a105-ffa892995899)
Acronym Type.AddTableKey [Power Query M: Add a key to a table type.](https://docs.microsoft.com/en-us/powerquery-m/type-addtablekey)
Acronym Type.ClosedRecord [Power Query M: The given type must be a record type returns a closed version of the given record type (or the same type, if it is already closed)](https://docs.microsoft.com/en-us/powerquery-m/type-closedrecord)
Acronym Type.Facets [Power Query M: Returns the facets of a type.](https://docs.microsoft.com/en-us/powerquery-m/type-facets)
Acronym Type.ForFunction [Power Query M: Creates a function type from the given .](https://docs.microsoft.com/en-us/powerquery-m/type-forfunction)
Acronym Type.ForRecord [Power Query M: Returns a Record type from a fields record.](https://docs.microsoft.com/en-us/powerquery-m/type-forrecord)
Acronym Type.FunctionParameters [Power Query M: Returns a record with field values set to the name of the parameters of a function type, and their values set to their corresponding types.](https://docs.microsoft.com/en-us/powerquery-m/type-functionparameters)
Acronym Type.FunctionRequiredParameters [Power Query M: Returns a number indicating the minimum number of parameters required to invoke the a type of function.](https://docs.microsoft.com/en-us/powerquery-m/type-functionrequiredparameters)
Acronym Type.FunctionReturn [Power Query M: Returns a type returned by a function type.](https://docs.microsoft.com/en-us/powerquery-m/type-functionreturn)
Acronym Type.Is [Power Query M: Type.Is](https://docs.microsoft.com/en-us/powerquery-m/type-is)
Acronym Type.IsNullable [Power Query M: Returns true if a type is a nullable type; otherwise, false.](https://docs.microsoft.com/en-us/powerquery-m/type-isnullable)
Acronym Type.IsOpenRecord [Power Query M: Returns whether a record type is open.](https://docs.microsoft.com/en-us/powerquery-m/type-isopenrecord)
Acronym Type.ListItem [Power Query M: Returns an item type from a list type.](https://docs.microsoft.com/en-us/powerquery-m/type-listitem)
Acronym Type.NonNullable [Power Query M: Returns the non nullable type from a type.](https://docs.microsoft.com/en-us/powerquery-m/type-nonnullable)
Acronym Type.OpenRecord [Power Query M: Returns an opened version of a record type, or the same type, if it is already open.](https://docs.microsoft.com/en-us/powerquery-m/type-openrecord)
Acronym Type.RecordFields [Power Query M: Returns a record describing the fields of a record type with each field of the returned record type having a corresponding name and a value that is a record of the form [ Type = type, Opional = logical ].](https://docs.microsoft.com/en-us/powerquery-m/type-recordfields)
Acronym Type.ReplaceFacets [Power Query M: Replaces the facets of a type.](https://docs.microsoft.com/en-us/powerquery-m/type-replacefacets)
Acronym Type.ReplaceTableKeys [Power Query M: Replaces the keys in a table type.](https://docs.microsoft.com/en-us/powerquery-m/type-replacetablekeys)
Acronym Type.TableColumn [Power Query M: Returns the type of a column in a table.](https://docs.microsoft.com/en-us/powerquery-m/type-tablecolumn)
Acronym Type.TableKeys [Power Query M: Returns keys from a table type.](https://docs.microsoft.com/en-us/powerquery-m/type-tablekeys)
Acronym Type.TableRow [Power Query M: Returns a row type from a table type.](https://docs.microsoft.com/en-us/powerquery-m/type-tablerow)
Acronym Type.TableSchema [Power Query M: Returns a table containing a description of the columns (i.e. the schema) of the specified table type.](https://docs.microsoft.com/en-us/powerquery-m/type-tableschema)
Acronym Type.Union [Power Query M: Returns the union of a list of types.](https://docs.microsoft.com/en-us/powerquery-m/type-union)
Acronym UNICHAR [Returns the Unicode character that is references by the given numeric value](https://support.microsoft.com/en-us/office/unichar-function-ffeb64f5-f131-44c6-b332-5cd72f0659b8)
Acronym UNICODE [Returns the number (code point) that corresponds to the first character of the text](https://support.microsoft.com/en-us/office/unicode-function-adb74aaa-a2a5-4dde-aff6-966e4e81f16f)
Acronym UNIQUE [Returns a list of unique values in a list or range](https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e)
Acronym UPPER [Converts text to uppercase](https://support.microsoft.com/en-us/office/upper-function-c11f29b3-d1a3-4537-8df6-04d0049963d6)
Acronym Uri.BuildQueryString [Power Query M: Assemble a record into a URI query string.](https://docs.microsoft.com/en-us/powerquery-m/uri-buildquerystring)
Acronym Uri.Combine [Power Query M: Returns a Uri based on the combination of the base and relative parts.](https://docs.microsoft.com/en-us/powerquery-m/uri-combine)
Acronym Uri.EscapeDataString [Power Query M: Encodes special characters in accordance with RFC 3986.](https://docs.microsoft.com/en-us/powerquery-m/uri-escapedatastring)
Acronym Uri.Parts [Power Query M: Returns a record value with the fields set to the parts of a Uri text value.](https://docs.microsoft.com/en-us/powerquery-m/uri-parts)
Acronym VALUE [Converts a text argument to a number](https://support.microsoft.com/en-us/office/value-function-257d0108-07dc-437d-ae1c-bc2d3953d8c2)
Acronym Value.Add [Power Query M: Returns the sum of the two values.](https://docs.microsoft.com/en-us/powerquery-m/value-add)
Acronym Value.As [Power Query M: Value.As is the function corresponding to the as operator in the formula language. The expression value as type asserts that the value of a value argument is compatible with type as per the is operator. If it is not compatible, an error is raised.](https://docs.microsoft.com/en-us/powerquery-m/value-as)
Acronym Value.Compare [Power Query M: Returns 1, 0, or -1 based on value1 being greater than, equal to, or less than the value2. An optional comparer function can be provided.](https://docs.microsoft.com/en-us/powerquery-m/value-compare)
Acronym Value.Divide [Power Query M: Returns the result of dividing the first value by the second.](https://docs.microsoft.com/en-us/powerquery-m/value-divide)
Acronym Value.Equals [Power Query M: Returns whether two values are equal.](https://docs.microsoft.com/en-us/powerquery-m/value-equals)
Acronym Value.Expression [Power Query M: Returns an AST that represents the value's expression.](https://docs.microsoft.com/en-us/powerquery-m/value-expression)
Acronym Value.Firewall [Power Query M: Value.Firewall](https://docs.microsoft.com/en-us/powerquery-m/value-firewall)
Acronym Value.FromText [Power Query M: Decodes a value from a textual representation, value, and interprets it as a value with an appropriate type. Value.FromText takes a text value and returns a number, a logical value, a null value, a DateTime value, a Duration value, or a text value. The empty text value is interpreted as a null value.](https://docs.microsoft.com/en-us/powerquery-m/value-fromtext)
Acronym Value.Is [Power Query M: Value.Is is the function corresponding to the is operator in the formula language. The expression value is type returns true if the ascribed type of vlaue is compatible with type, and returns false if the ascribed type of value is incompatible with type.](https://docs.microsoft.com/en-us/powerquery-m/value-is)
Acronym Value.Metadata [Power Query M: Returns a record containing the inputs metadata.](https://docs.microsoft.com/en-us/powerquery-m/value-metadata)
Acronym Value.Multiply [Power Query M: Returns the product of the two values.](https://docs.microsoft.com/en-us/powerquery-m/value-multiply)
Acronym Value.NativeQuery [Power Query M: Evaluates a query against a target.](https://docs.microsoft.com/en-us/powerquery-m/value-nativequery)
Acronym Value.NullableEquals [Power Query M: Returns a logical value or null based on two values .](https://docs.microsoft.com/en-us/powerquery-m/value-nullableequals)
Acronym Value.Optimize [Power Query M: If value represents a query that can be optimized, returns the optimized query. Otherwise returns value.](https://docs.microsoft.com/en-us/powerquery-m/value-optimize)
Acronym Value.RemoveMetadata [Power Query M: Removes the metadata on the value and returns the original value.](https://docs.microsoft.com/en-us/powerquery-m/value-removemetadata)
Acronym Value.ReplaceMetadata [Power Query M: Replaces the metadata on a value with the new metadata record provided and returns the original value with the new metadata attached.](https://docs.microsoft.com/en-us/powerquery-m/value-replacemetadata)
Acronym Value.ReplaceType [Power Query M: A value may be ascribed a type using Value.ReplaceType. Value.ReplaceType either returns a new value with the type ascribed or raises an error if the new type is incompatible with the values native primitive type. In particular, the function raises an error when an attempt is made to ascribe an abstract type, such as any. When replacing a the type of a record, the new type must have the same number of fields, and the new fields replace the old fields by ordinal position, not by name. Similarly, when replacing the type of a table, the new type must have the same number of columns, and the new columns replace the old columns by ordinal position.](https://docs.microsoft.com/en-us/powerquery-m/value-replacetype)
Acronym Value.Subtract [Power Query M: Returns the difference of the two values.](https://docs.microsoft.com/en-us/powerquery-m/value-subtract)
Acronym Value.Type [Power Query M: Returns the type of the given value.](https://docs.microsoft.com/en-us/powerquery-m/value-type)
Acronym VAR [Estimates variance based on a sample](https://support.microsoft.com/en-us/office/var-function-1f2b7ab2-954d-4e17-ba2c-9e58b15a7da2)
Acronym VAR.P [Calculates variance based on the entire population](https://support.microsoft.com/en-us/office/var-p-function-73d1285c-108c-4843-ba5d-a51f90656f3a)
Acronym VAR.S [Estimates variance based on a sample](https://support.microsoft.com/en-us/office/var-s-function-913633de-136b-449d-813e-65a00b2b990b)
Acronym VARA [Estimates variance based on a sample, including numbers, text, and logical values](https://support.microsoft.com/en-us/office/vara-function-3de77469-fa3a-47b4-85fd-81758a1e1d07)
Acronym Variable.Value [Power Query M: Variable.Value](https://docs.microsoft.com/en-us/powerquery-m/variable-value)
Acronym VARP [Calculates variance based on the entire population](https://support.microsoft.com/en-us/office/varp-function-26a541c4-ecee-464d-a731-bd4c575b1a6b)
Acronym VARPA [Calculates variance based on the entire population, including numbers, text, and logical values](https://support.microsoft.com/en-us/office/varpa-function-59a62635-4e89-4fad-88ac-ce4dc0513b96)
Acronym VDB [Returns the depreciation of an asset for a specified or partial period by using a declining balance method](https://support.microsoft.com/en-us/office/vdb-function-dde4e207-f3fa-488d-91d2-66d55e861d73)
Acronym VLOOKUP [Looks in the first column of an array and moves across the row to return the value of a cell](https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1)
Acronym Web.BrowserContents [Power Query M: Returns the HTML for the specified url, as viewed by a web browser.](https://docs.microsoft.com/en-us/powerquery-m/web-browsercontents)
Acronym Web.Contents [Power Query M: Returns the contents downloaded from a web url as a binary value.](https://docs.microsoft.com/en-us/powerquery-m/web-contents)
Acronym Web.Page [Power Query M: Returns the contents of an HTML webpage as a table.](https://docs.microsoft.com/en-us/powerquery-m/web-page)
Acronym WebAction.Request [Power Query M: Creates an action that, when executed, will return the results of performing a method request against url using HTTP as a binary value.](https://docs.microsoft.com/en-us/powerquery-m/webaction-request)
Acronym WebMethod.Delete [Power Query M: Specifies the DELETE method for HTTP.](https://docs.microsoft.com/en-us/powerquery-m/webmethod-delete)
Acronym WebMethod.Get [Power Query M: Specifies the GET method for HTTP.](https://docs.microsoft.com/en-us/powerquery-m/webmethod-get)
Acronym WebMethod.Head [Power Query M: Specifies the HEAD method for HTTP.](https://docs.microsoft.com/en-us/powerquery-m/webmethod-head)
Acronym WebMethod.Patch [Power Query M: Specifies the PATCH method for HTTP.](https://docs.microsoft.com/en-us/powerquery-m/webmethod-patch)
Acronym WebMethod.Post [Power Query M: Specifies the POST method for HTTP.](https://docs.microsoft.com/en-us/powerquery-m/webmethod-post)
Acronym WebMethod.Put [Power Query M: Specifies the PUT method for HTTP.](https://docs.microsoft.com/en-us/powerquery-m/webmethod-put)
Acronym WEBSERVICE [Returns data from a web service.](https://support.microsoft.com/en-us/office/webservice-function-0546a35a-ecc6-4739-aed7-c0b7ce1562c4)
Acronym WEEKDAY [Converts a serial number to a day of the week](https://support.microsoft.com/en-us/office/weekday-function-60e44483-2ed1-439f-8bd0-e404c190949a)
Acronym WEEKNUM [Converts a serial number to a number representing where the week falls numerically with a year](https://support.microsoft.com/en-us/office/weeknum-function-e5c43a03-b4ab-426c-b411-b18c13c75340)
Acronym WEIBULL [Calculates variance based on the entire population, including numbers, text, and logical values](https://support.microsoft.com/en-us/office/weibull-function-b83dc2c6-260b-4754-bef2-633196f6fdcc)
Acronym WEIBULL.DIST [Returns the Weibull distribution](https://support.microsoft.com/en-us/office/weibull-dist-function-4e783c39-9325-49be-bbc9-a83ef82b45db)
Acronym WORKDAY [Returns the serial number of the date before or after a specified number of workdays](https://support.microsoft.com/en-us/office/workday-function-f764a5b7-05fc-4494-9486-60d494efbf33)
Acronym WORKDAY.INTL [Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days](https://support.microsoft.com/en-us/office/workday-intl-function-a378391c-9ba7-4678-8a39-39611a9bf81d)
Acronym XIRR [Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic](https://support.microsoft.com/en-us/office/xirr-function-de1242ec-6477-445b-b11b-a303ad9adc9d)
Acronym XLOOKUP [Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. ](https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929)
Acronym XMATCH [Returns the relative position of an item in an array or range of cells. ](https://support.microsoft.com/en-us/office/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312)
Acronym Xml.Document [Power Query M: Returns the contents of an XML document as a hierarchical table (list of records).](https://docs.microsoft.com/en-us/powerquery-m/xml-document)
Acronym Xml.Tables [Power Query M: Returns the contents of an XML document as a nested collection of flattened tables.](https://docs.microsoft.com/en-us/powerquery-m/xml-tables)
Acronym XNPV [Returns the net present value for a schedule of cash flows that is not necessarily periodic](https://support.microsoft.com/en-us/office/xnpv-function-1b42bbf6-370f-4532-a0eb-d67c16b664b7)
Acronym XOR [Returns a logical exclusive OR of all arguments](https://support.microsoft.com/en-us/office/xor-function-1548d4c2-5e47-4f77-9a92-0533bba14f37)
Acronym YEAR [Converts a serial number to a year](https://support.microsoft.com/en-us/office/year-function-c64f017a-1354-490d-981f-578e8ec8d3b9)
Acronym YEARFRAC [Returns the year fraction representing the number of whole days between start_date and end_date](https://support.microsoft.com/en-us/office/yearfrac-function-3844141e-c76d-4143-82b6-208454ddc6a8)
Acronym YIELD [Returns the yield on a security that pays periodic interest](https://support.microsoft.com/en-us/office/yield-function-f5f5ca43-c4bd-434f-8bd2-ed3c9727a4fe)
Acronym YIELDDISC [Returns the annual yield for a discounted security; for example, a Treasury bill](https://support.microsoft.com/en-us/office/yielddisc-function-a9dbdbae-7dae-46de-b995-615faffaaed7)
Acronym YIELDMAT [Returns the annual yield of a security that pays interest at maturity](https://support.microsoft.com/en-us/office/yieldmat-function-ba7d1809-0d33-4bcb-96c7-6c56ec62ef6f)
Acronym Z.TEST [Returns the one-tailed probability-value of a z-test](https://support.microsoft.com/en-us/office/z-test-function-d633d5a3-2031-4614-a016-92180ad82bee)
Acronym ZTEST [Returns the one-tailed probability-value of a z-test](https://support.microsoft.com/en-us/office/ztest-function-8f33be8a-6bd6-4ecc-8e3a-d9a4420c4a6a)