MS Excel | Excel In Excel

Power Query M Functions

Microsoft Power Query helps the users with highly efficient data import services. It works with Excel, Analysis Services, and Power BI. The key feature here is the ability to filter and combine data from varied data sources and provide the reader with the required output. The process is expressed using a language called Power Query M Formula language. This language is case sensitive.

The Power Query M Functions help to work with ease with data models using formulas and expressions. A function in the Power Query M formula language is a mapping from a set of input values to a single output value.
While writing a function the function parameters are named first and then an expression to compute the result of the function is provided.
A function is a value just like a number or a text value and can be included in-line just like any other expression. A function which is the value of a variable can then be invoked from several other variables. When a function is invoked, a set of values are specified which are logically substituted for the required set of input values within the function body expression.

Accessing Data Function

Excel.CurrentWorkbook Finds the tables in the current workbook
Excel.Workbook Finds the sheet in the workbook workbookHeaders
Exchange.Contents Returnss the table of content from the mailbox address
Csv.Document Convertss the CSV document as a table sourcecolumnsdelimeterextra valuesencoding
Csv.Style.QuoteAfterDelimiter Quotes a field that is significant immediately following the delimiter
Csv.Style.QuoteAlways Quotes in a field that is always significant
Folder.Files Returns the file from the given folder path pathoptions

Binary Function

Binary.Buffer Retrieves the buffers binary value stable binary values functionTypefunction
Binary.Combine Combines a Returns of binaries and Returnss a single binary agrfunction
Binary.Compress Compress the given binary value functiondelay
Binary.Decompress Compresses the binary value using the given decompression type function
Binary.From Returns a binary value based on the given value scalarFunctionTypevector Function
Binary.Length Obtains number of characters in the binary value value
Binary.ToList Returns numbers from the given binary value documentenvironment
Binary.ToText Acquires text value for the given binary number name
Binary.FromText Obtains binary values for the given text values
Binary.FromList Obtains binary values form given Returns of numbers traceLevelmessagevaluedelayed
Binary Obtains binary value reasonmessagedetail

Combiner Function

Combiner.CombineTextByDelimiter Combines a text in a single text delimiterquotestyle
Combiner.CombineTextByEachDelimiter Combines a text in a single text delimiterquotestyle
Combiner.CombineTextByRanges Combines a text in a single text rangetemplate
Combiner.CombineTextByPositions Combines a text in a single text Positiontemplate
Combiner.CombineTextByLengths Combines a text in a single text lengthtemplate

Comparer Function

Comparer.Equals Presents a logical value based on equality Check comparerxy
Comparer.FromCulture Compares logical values based on the given culture cultureignorecase
Comparer.Ordinal Compares the given values x any y using ordinal rules xy
Comparer.OrdinalIgnoreCase Compares the given values x any y using case-insensitive ordinal rules xy

Date Function

Date.AddDays Returns the date, datetime, or date time zone by adding Days dateTime as anynumberOfDays
Date.AddMonths Acquires the date, DateTime, or date-time zone dateTime as anynumberOfMonths
Date.AddQuarters Acquires the date, DateTime, or date-time zone dateTime as anynumberOfQuarters
Date.AddWeeks Returns the date, DateTime, or date timezone by adding a number of Weeks dateTime as anynumberOfWeeks
Date.AddYears Returns the date, DateTime, or date timezone by adding a number of Years dateTime as anynumberOfYears
Date.Day Extracts day from date, Date Time or date timezone value date or datetime or datetimezone
Date.DayOfWeek Returns a number from 0 to 6 that indicates the day of the week dateTimeFirstdayofweek
Date.DayOfWeekName Returns the name of the week for a date DateCulture
Date.DayOfYear Returns a number that indicates the day of the year dateTime
Date.DayOfMonth Returns a number that indicates the day of the Month dateTime
Date.EndOfDay Finds the last value of the date, DateTime, or date-time zone dateTime
Date.EndOfMonth Returns the last date of the month from the user-defined date dateTime
Date.EndOfQuarter Returns the end of the quarter from the user-defined date dateTime
Date.EndOfWeek Returns the last day of the week from the user-defined date firstdayofweek
Date.EndOfYear Returns the last day of the year which user-defined dateTime
Date.From Returns the date from the value valueculture
Date.FromText Returns the date from the text textculture
Date.IsInCurrentDay whether the provided DateTime value occurs during the current day dateTime
Date.IsInCurrentMonth whether the provided DateTime value occurs during the current month dateTime
Date.IsInCurrentQuarter whether the provided DateTime value occurs during the current quarter dateTime
Date.IsInCurrentWeek whether the provided DateTime value occurs during the current week dateTime
Date.IsInCurrentYear whether the provided DateTime value occurs during the current year dateTime
Date.IsInNextDay whether the provided DateTime value occurs during the NextDay dateTime
Date.IsInNextMonth whether the provided DateTime value occurs during the NextMonth dateTime
Date.IsInNextNDays whether the provided DateTime value occurs during the next number of days dateTimedays
Date.IsInNextNMonths whether the provided DateTime value occurs during the next number of months dateTimemonths
Date.IsInNextNquarters whether the provided DateTime value occurs during the next number of quarters dateTimequarters
Date.IsInNextNWeeks whether the provided DateTime value occurs during the next number of weeks dateTimeweeks
Date.IsInPreviousNMonths whether the provided DateTime value occurs during the previous number of months dateTimemonths
Date.IsInPreviousNQuarters whether the provided DateTime value occurs during the previous number of quarters dateTimequarters
Date.IsInPreviousNWeeks whether the provided DateTime value occurs during the previous number of weeks dateTimeweeks
Date.IsInPreviousNYears whether the provided DateTime value occurs during the previous number of years dateTimeyears
Date.IsInPreviousQuarter whether the provided DateTime value occurs during the previous Quarter dateTime
Date.IsInPreviousWeek whether the provided DateTime value occurs during the previous week dateTime
Date.IsInPreviousYear whether the provided DateTime value occurs during the previous year dateTime
Date.IsInYearToDate whether the provided DateTime value occurs during the current year and is on or before the current day dateTime
Date.IsLeapYear whether the provided DateTime value is a leap year or not dateTime
Date.Month Returns the month from the given date dateTime
Day.Friday Ascertains the number6 that represents specified weekend
Day.Monday Ascertains the number 2 that represents specified weekday
Day.Saturday Ascertains the number 7 that represents specified weekend
Day.Sunday Ascertains the number 1 that represents specified weekday
Day.Thursday Ascertains the number 5 that represents specified weekday
Day.Tuesday Returns a number 3 that represents specified weekday
Day.Wednesday Ascertains the number 4 that represents specified weekday
Date Create a date value yearmonths
Date.IsInNextNYears whether the provided DateTime value occurs during the next number of Years datetimeYears
Date.IsInNextQuarter whether the provided DateTime value occurs during the next quarter datetime
Date.IsInNextWeek whether the provided DateTime value occurs during the next week datetime
Date.IsInNextYear whether the provided DateTime value occurs during the next Year datetime
Date.IsInPreviousDay whether the provided DateTime value occurs during the Previous Day datetime
Date.IsInPreviousMonth Whether the provided DateTime value occurs during the previous month datetime
Date.IsInPreviousNDays whether the provided DateTime value occurs during the Previous number of Days datetimedays
Date.MonthName know the month of the given date datetimeculture
Date.QuarterOfYear which quarter of the year the date falls in datetime
Date.StartOfDay Obtains the first date, DateTime, or date-time zone, form the given DateTime by the user datetime
Date.StartOfMonth Obtains the first date of the month from the user-defined date datetime
Date.StartOfQuarter Returns the start of the quarter from the user-defined date datetime
Date.StartOfWeek Obtains the start day of the week which the user-defined datetimefirstDayOfWeek
Date.StartOfYear Obtains the start day of the year which the user-defined datetime
Date.ToRecord Obtains the date into separate records date
Date.ToText Obtains the text of the date dateformatculture
Date.WeekOfMonth Obtains the week of the month from the user-defined datetime datetimefirstDayOfWeek
Date.WeekOfYear Obtains the week of the year from the user-defined datetime datetimefirstDayOfWeek
Date.Year Returns the year from the user-defined datetime datetime

DateTime Function

DateTime.IsInNextMinute whether the provided DateTime value occurs during the next minute dateTime
DateTime.IsInNextNHours whether the provided DateTime value occurs during the next number of hours dateTimehours
DateTime.IsInNextSecond Checks whether the provided DateTime value occurs during the next second dateTime
DateTime.IsInPreviousHour whether the provided DateTime value occurs during the previous hour dateTime
DateTimeZone.ToLocal Converts a timezone value to local timezone value dateTimeZone
DateTimeZone.ToRecord Returns the datetimezone into separate records dateTimeZone
DateTimeZone.ToText Returns the text formation from the given value dateTimeZoneFormat
DateTimeZone.ToUtc Converts a timezone value to Utc or universal time dateTimeZone
DateTimeZone.ToUtcNow Converts a timezone to Utc No parameters
DateTimeZone.ZoneHours Converts a timezone to zone hours dateTimeZone
DateTimeZone.ZoneMinutes Converts a timezone to zone minutes dateTimeZone
DateTimeZone Creates a datetimezone value yearmonth
DateTime.AddZone Sets the timezone information on the DateTime value datetimetimezoneMinutes
DateTime.Date Returns the date component from the date, datetime, or datetimezone value datetime
DateTime.FixedLocalNow Returns the current date and time based on the local zone datetime
DateTime.From Returns the date-time from the given values Valueculture
DateTime.FromFileTime Returns the date time from the window file time value and it Convertss it to the local time zon filetime
DateTime.FromText Converts the date values from the text Valueculture
DateTime.IsInCurrentHour whether the provided DateTime value occurs during the current hour datetime
DateTime.IsInCurrentMinute whether the provided DateTime value occurs during the Current minute datetime
DateTime.IsInCurrentSecond whether the provided DateTime value occurs during the current second datetime
DateTime.IsInNextHour whether the provided DateTime value occurs during the next hour datetime
DateTime.IsInNextNMinutes whether the provided DateTime value occurs during the next number of minutes datetimeminutes
DateTime.IsInNextNSeconds whether the provided DateTime value occurs during the next number of seconds datetimeseconds
DateTime.IsInPreviousMinute whether the provided DateTime value occurs during the previous minute datetime
DateTime.IsInPreviousNHours whether the provided DateTime value occurs during the previous number of hours datetimehours
DateTime.IsInPreviousNMinutes whether the provided DateTime value occurs during the previous number of minutes datetimeminutes
DateTime.IsInPreviousNSeconds whether the provided DateTime value occurs during the previous number of seconds datetimeseconds
DateTime.IsInPreviousSecond whether the provided DateTime value occurs during the previous second datetime
DateTime.LocalNow Acquires the current date and time based on the local zone datetime
DateTime.Time Returns the time by given datetime value datetime
DateTime.ToRecord Converts DateTime value into records containing of date time values datetime
DateTime.ToText Obtains the text from the datetime datetimeformatculture
DateTime create a datetime value yearmonthdayhourminute

DateTimeZoneFunction

DateTimeZone.FixedLocalNow Returns the current date and time based on the local zone datetime
DateTimeZone.FixedUtcNow Returns the current date and time datetime
DateTimeZone.From Returns the date-time-zone from the given values Valueculture
DateTimeZone.FromFileTime Returns the date time from the window file time value and it Convertss it to the local time zone filetime
DateTimeZone.FromText coverts the date values from the text Valueculture
DateTimeZone.LocalNow Returns the current datetimeZone based on the local zone datetime
DateTimeZone.RemoveZone Returns the only the DateTime without the Time zone datetime
DateTimeZone.SwitchZone Switchs the old timezone to new timezone which information are provided in provided by timezoneHours datetimezone,timezoneHourstimezoneMinute
DateTimeZone.UtcNow Returns the current date and time datetime

Duration FunctionFunction

Duration.TotalMinutes Returns total minutes spanned Duration
Duration.TotalSeconds Returns total Seconds spanned Duration
Duration.TotalHours Returns total hours spanned Duration
Duration.TotalDays Returns total days spanned Duration
Duration.FromText Retrieves the duration value from the provided text value text
Duration.From Returns the textual rePresentsation in the form day hour:mins:sec durationformat
Duration.ToText Returns the duration value from the provided value value
Duration.ToRecord Obtains a record that contains parts of duration value Duration
Duration.Days Obtains day component from the provided duration value Duration
Duration.Hours Obtains hour component from the provided duration value Duration
Duration.Minutes Obtains minute component from the provided duration value Duration
Duration.Seconds Obtains second component from the provided duration value Duration

Error handling Function

Diagnostics.ActivityId Presents an nullable text listpagesize
Diagnostics.Trace Presents an value by writing a trace message number list
Error.Record Presents record of values listprecision
TraceLevel.Critica Ascertains the value of critical trace level
TraceLevel.Error Ascertains the value for error trace level
TraceLevel.Warning Ascertains the value for warning trace level
TraceLevel.Information Ascertains the value for information trace level
TraceLevel.Verbose Ascertains the value for verbose trace level

Expression value functionFunction

Expression.Constant Presents the constant value listcounterorcondition
Expression.Evaluate Returns the result of evaluating an M expression document listcomparisonCriteria
Expression.Identifier Express representation of an identifier list

Function valuesFunction

Function.From present the new Returns by applying the arguments list
Function.Invoke Presents the new returns by applying this function listequation criteria
Function.InvokeAfter Presents the returns by applying this function listselection
Function.IsDataSource Presents the new returns by applying this function list
Function.ScalarVector Returnss its single output listdefault

Lines Function

Lines.FromBinary Ascertains text values from the binary value binaryquoteStyleincludeLineSeparatorsencodingaggregationFunction
Lines.FromText Returns list of text values from the text value textquoteStyleincludeLineSeparatorsencoding
Lines.ToBinary Converts a Returns of text ina binary value startcountstep
Lines.ToText Converts a Returns of text ina single text listtransform

List Function

List.Intersect Obtains intersect values from the values and given the output in list(vertical ) manner listsequationCriteria
List.IsDistinct Returns whether there are duplicates values listequationCriteria
List.IsEmpty Returns the list have any empty in it list
List.Last Acquires the last number listdefault value
List.LastN Acquires the lastN number, and we can also specify how many values to return listcountorcondition
List.MatchesAll Check whether given condition matches all criteria listcondition
List.MatchesAny whether the given condition satisfies any one criteria listcondition
List.Max Returns a maximum value from a given range listdefaultcomparsionCriteriaincludeNulls
List.MaxN Returns The N Maximum value from the given list listcountorconditioncomparsionCriteriaincludeNulls
List.Min Returns a maximum value from a given range listdefaultcomparsionCriteriaincludeNulls
List.MinN Returns a minmum value from a given range listcountorconditioncomparsionCriteriaincludeNulls
List.Accumulate Obtains a running total or accumulated total from the given list ListSeedaccumulator
List.Median Acquires the median of a group of numbers listcomparsionCriteria
List.Mode Acquires the most frequently occurring number listequationCriteria
List.Modes Acquires the most frequently occurring number listequationCriteria
List.NonNullCount counts the number of non -null items in the given list list
List.Numbers returns a list of numbers starting at 1 startcountincrement
List.PositionOf Positios of the values from the given list listvalueocurrenceequationCriteria
List.PositionOfAny Positions of the values from the given list listvalueocurrenceequationCriteria
List.Positions Returns the list of offsets for the input list list
List.Product Returns the product of the supplied numbers numberlistprecision
List.Random Obtains random number between 0 and 1 countseed
List.AllTrue Returns true if expressions on the list are true list
List.Alternate Returns a list comprised of all the odd numbered offset elements listCountrepeat intervaloffset
List.AnyTrue Returns true if any expressions on the list are true list
List.Average Returns the average value for the given items in a list listprecision
List.Buffer Buffers the list in memory lists
List.Combine Returns lists into one single new sheet list
List.Contains Obtains if the list contains the values listvalueequationCrieteria
List.ContainsAll Obtains if the list includes all the values in another list listvalueequationCrieteria
List.ContainsAny Obtains if the list includes any of the values in another list listvalueequationCrieteria
List.Count Obtains the number of items in the list list
List.Range Obtains number from the given range listoffsetcount
List.RemoveFirstN Removes first appears numerical in the list listcountOrcondition
List.Covariance Returns the covariance between list 1 and list 2 numberlist1numberlist2
List.Dates Return list of date values of size count, starting at start startcountstep
List.DateTimes Returns list of datetime values of size count, starting at start startcountstep
List.DateTimeZones Returns list of datetimezone values of size count, starting at start startcountstep
List.Difference Returns the items in list1 that do not appear in list2 list1list2equationCriteria
List.Distinct Returns a list that contains all the values in list, with duplicates Removesd listequationCriteria
List.Durations Returnss a list of count duration values, starting at start and incremented by the given duration step startcountstep
List.FindText Returns a specific text from a list listtext
List.First Obtains first value from the list listdefault Value
List.FirstN Obtains the specified number value from the list listcountorcondition
List.Generate Generates the list of values from the given functions initialconditionnextselector
List.InsertRange Obtains a new list Generatesd by inserting the given values in the arguments listindexvalues
List.RemoveItems Returns a list with text and numbers with required additions and deletions linesLineSeparatorsencodingincludeByteordermark
List.RemoveLastN lists text and numbers with specified deletions linesLineSeparators
List.RemoveMatchingItems Eliminates the similar occurrences of list 2 from the list 1 binary
List.RemoveNulls Lists elements other than nulls binaries
List.RemoveRange Eliminates the values in the list with the help of starting point binarycompressionType
List.TransformMany Returns the resultant element by applying collection transform function binarycompressionType
List.Repeat Returns the repeated value Valueencoding
List.ReplaceMatchingItems Replaces the old value with the new value in the Returns binary
List.ReplaceRange Replaces count values in the new Returns with specified Index binary
List.ReplaceValue Replaces values in the new Returns binaryencoding
List.Reverse Returns the elements in reverse order binaryencoding
List.Union Returns the value in individual Returns and Returnss the output in a single sheet list
List.Select Returns the selected value value
List.Single Returns the single elements required List1List2
List.SingleOrDefault Returns the selected single or default List1Counterorcondition
List.Skip Returnss the elements after skipping required elements list1list2equationCrieteria
List.Sort Enables us sort the elements of the Returns in a specified order list
List.Zip Returns the data at same positions listindexcount
List.Split Returns the split data listcollectionTransformresultTransform
List.StandardDeviation Returns the standard deviation of the numbers in the Returns based on samples listcount
List.Sum Returns the sum of the numbers in the Returns listreplacementsequationCriteria
List.Times Returns the time value listindexcountreplace with
List.Transform Presents the new Returns by applying this function listold valuenew valuereplacer

Logical Function

Logical.From Obtains a logical value Value
Logical.FromText Ascertains a logical value from text text
Logical.ToText Acquires a text from logical value logical value

Number Function

Number.Asin Obtains the arcsine of a number number
Number.Atan Returns the arctangent of a number number
Number.Atan2 Returns the arctangent of a x and y coordinates yx
Number.BitwiseAND Returns the end results of BitwiseAND operation number1number2
Number.BitwiseNot Returns the end results of BitwiseNot operation number
Number.BitwiseOr Returns the end results of BitwiseOr operation number1number2
Number.BitwiseShiftLeft shift bitwise left to the number specified by number of bits number1number2
Number.BitwiseShiftRight shift bitwiseright to the number specified by number of bits number1number2
Number.BitwiseXor Returns the end results of BitwiseXor operation number1number2
Number.Combinations Gets the number of combinations available in a list setSizecombinationSize
Number.FromText Returns a number value for the given text value textculture
Number.IntegerDivide Divide 2 numbers and Returns the integer value of it number1number2
Number.IsEven Check if the given numerical is even or not number
Number.IsNaN Check whether given value is not a numerical value number
Number.IsOdd Check if the given numerical value is odd or not number
Byte.From Coverts the numerical to 8 -integer valuecultureroundingmode
Currency.From Converts number value to currency value valuecultureroundingmode
Decimal.From Converts number value to decimal value valueculture
Double.From Converts number value into double value valueculture
Int8.From Converts the numerical value into signed 8-bit integer valuecultureroundingmode
Int16.From Converts the numerical value into signed 16-bit integer valuecultureroundingmode
Int32.From Converts the numerical value into signed 32-bit integer valuecultureroundingmode
Int64.From Converts the numerical value into signed 64-bit integer valuecultureroundingmode
Number.Abs Returns a absolute value number
Number.Acos Returns a arccosine value number
Number.Cos Returns a cosine value number
Number.Cosh Returns a hyperbolic cosine value number
Number.Exp Returns the value of e-raised to the power of a number number
Number.Factorial Returns factorial of a number number
Number.From Returns a numeric values valueculture
Number.Ln Acquires the natural logarithm of a number number
Number.Log Acquires the logarithm of a number from the given value numberbase
Number.Log10 Obtains the base-10 logarithm of a number number
Number.Mod Acquires reminder value for the given Number numberdivisorprecision
Number.Permutations Obtains the each possible arrangement for the given number setsizepermutationSize
Number.Power Obtains raise a number to a power for the given number numberpower
Number.ToText Acquires text from the given numerical value numberformatculture
Percentage.From Acquiress Percentage value from the given numerical value valueculture
Number.Random Obtains a random number between 0 to 7
Number.RandomBetween Obtains a random number between the top and bottom bottomtop
Number.Round Rounds a number to the nearest number numberdigitsroundingMode
Number.RoundAwayFromZero Rounds a number based on the sign of the number numberdigits
Number.RoundDown Rounds a number down to the nearest integer numberdigits
Number.RoundTowardZero Rounds a number based on the sign of the number numberdigits
Number.RoundUp Rounds a number down to the nearest integer numberdigits
Number.Sign Number to Check whether the given number is positive, negative or zero number
Number.Sin Specifies the sin of a number number
Number.Sinh Specifies the sinh of a number number
Number.Sqrt Ascertain the square root of a given number number
Number.Tan Specifies the tangent of a number number
Number.Tanh Specifies the hyperbolic tangent of a number number
Number.PI Returns the value of Pi
RoundingMode.Up Rounds up the value
RoundingMode.Down Rounds down the value
RoundingMode.AwayFromZero ascertain the value away from zero
RoundingMode.TowardZero Ascertains the value toward zero
RoundingMode.ToEven Ascertains the value Even number
Number.NaN Ascertains a constant of 0 divided by
Number.NegativeInfinity Ascertains constant value -1 divided by 0
Number.PositiveInfinity Ascertains a constant value of 1 divided by 0
Number.Epsilon Ascertains a smallest positive number
Single.From Ascertains Single number value from the given value valueculture

Record Function

Record.FieldCount Obtains a number of fields into record record
Record.HasFields Knows if the specified field is present in the list recordfields
Record.AddField Adds a field into a record recordFieldNamevaluesdelayed
Record.Combine Combine the records records
Record.RemoveFields Removes specific fields from the records recordfieldsmissingField
Record.RenameFields Rename specific fields from the records recordrenamemissingField
Record.ReorderFields Reorders specific fields from the records recordreordermissingField
Record.TransformFields Transforms a field in a record recordtransformOperationsmissingField
Record.Field Returns a value from record recordfield
Record.FieldNames Returns name of the field from the record record
Record.FieldOrDefault Returns the specifiel field else the default value recordfielddefaultValue
Record.FieldValues Returnss a list of the field values in record record
Record.SelectFields records specified fields under the list argument recordfieldsmissingField
Record.FromList Returns a record given a list of field values and a set of field listfields
Record.FromTable Returns a record from table records containing field names and value names table
Record.ToList Returns a list of values containing the field values from the input record
Record.ToTable Returns the table from the record record
MissingField.Error Indicates that missing fields should result in an error tablecolumncolumnNamesnewColumnNames
MissingField.Ignore Indicates that missing fields should be ignored tabletransform
MissingField.UseNull Indicates that missing fields should be included as null values tablecolumn

Replacer Function

Replacer.ReplaceText Replaces a text textoldnew
Replacer.ReplaceValue Replaces a text valueoldnew

Splitter Function

Splitter.SplitByNothing Returnss a function that does no splitting, Returnsing its argument as a single element list
Splitter.SplitTextByAnyDelimiter split a text using delimiter delimiterquoteStylestartAtEnd
Splitter.SplitTextByCharacterTransition Returns a function that splits text ina list of text according a transition from one kind of character another beforeafter
Splitter.SplitTextByDelimiter split text ina list of text according the specified delimiter delimiterquoteStyle
Splitter.SplitTextByEachDelimiter splits text ina list of text at each specified delimiter in sequence delimiterquoteStylestartAtEnd
Splitter.SplitTextByLengths splits text ina list of text at each specified delimiter in sequence lengthstartAtEnd
Splitter.SplitTextByPositions splits text in a list of text at each specified position positionsstartAtEnd
Splitter.SplitTextByRanges splits text in a list of text according the specified offsets and lengths rangesstartAtEnd
Splitter.SplitTextByRepeatedLengths splits text in a list of text after the specified length repeatedly lengthstartAtEnd
Splitter.SplitTextByWhitespace splits text in a list of text at whitespace quoteStyle
QuoteStyle.None Quotes characters have no significance table
QuoteStyle.Csv Quotes characters indicate the start of a quoted string table

Table Function

Table.Partition split the table inlist of tables based on the group. tablecolumngroupshash
Table.Range Begin table row from the given range tableoffsetcount
Table.RemoveFirstN omit first row of the table tablecountOrcondition
Table.RemoveLastN omit last row of the table tablecountOrcondition
Table.RemoveRows Removes row of the table tableoffsetcount
Table.RemoveRowsWithErrors Removes error value from the given table tableColumns
Table.Repeat repeat rows as specified tablecount
Table.ReplaceRows Replacess rows as specified tableoffsetcountrows
Table.ReverseRows Obtains the entire rows in backwards order table
Table.SelectRows Inspect and display the rows which meet the satisfy the condition given by the user tablecondition
Table.SelectRowsWithErrors picks only the row has an error value in the table tableColumns
Table.Skip skip number of row tablecountOrcondition
Table.SingleRow Converts the rows into table table
Table.Column Returns the specified data from the column tablecolumn
Table.ColumnNames Obtains the column names from the table table table
Table.ColumnsOfType retrieves specified types of list from given column in the table tablelistoftypes
Table.DemoteHeaders Returnss the column headers to the first row table
Table.HasColumns Indicates whether the table have contains the specified column tableColumns
Table.SelectColumns inspect and display the columns which satisfy the condition given by the user tableColumnsmissingFiled
Table.PrefixColumns prefix the text with all the column names tableprefix
Table.PromoteHeaders Returnss the first rows value as the column header tableoptions
Table.DuplicateColumn Check whether there is any repetition of the column name tablecolumnNamenewColumnNameColunmType
Table.RemoveColumns Removes specific columns from the table tableColumnsmissingField
Table.RenameColumns rename specific columns from the table tablerenamesmissingField
Table.ReorderColumns rename specific columns from the table tablecolumnsOrdermissingField
Table.TransformColumnNames transform columns name from the table tablenameGeneratoroption
Table.InsertRows Inserts a row in a table
Table.LastN Acquires lastN row
Table.Last Acquires last row from the given
Table.MatchesAllRows Examines whether all the rows in the table meets the condition
Table.MatchesAnyRows Examines whether any of the rows in the table meets the condition
Table.AddColumn Adds on new column the table table
Table.FillUp Fills the null columns inthe table tableoffsetskiptake
Table.ExpandListColumn Expands the given Returns tableoffsetrows
Table.ExpandTableColumn Expands columns from the given table tablecountorCondition
Table.TransformRows Transforms the row value tabledefault
Table.Transpose Converts columns inrows and rows incolumn tablecondition
Table.ToRows Returns of nested Returns tablecondition
Table.ToColumns Returns of nested Returns tablenewColumnNamecolumnGeneratorcolumntype
Table.Contains Inspects whether the specified record, row appears the table tablecolumns
Table.ContainsAll Inspects whether the all specified record, row appears the table tablecolumn
Table.ColumnCount Returns the number of columns in a table tablerowequationCriteria
Table.AlternateRows Takes and skip the give rows (table, offset, skip and take) tablerowequationCriteria
Table.ContainsAny Inspect whether any of the specified record, row appears the table tablerowequationCriteria
Table.IsDistinct Check whether given rows are distinct tablecomparsionCriteria
Table.PositionOf Obtains the row position from the given table input tablerowoccurrenceequationCriteria
Table.PositionOfAny Obtains row(s) position(s) from the given table input tablerowoccurrenceequationCriteria
Table.RemoveMatchingRows Removes all matching rows tablerowequationCriteria
Table.ReplaceMatchingRows Replaces all matching rows tablereplacementequationCriteria
Table.Max Obtains the row which has largest value tablecomparisonCriteriadefault
Table.MaxN Returns the N Maximum value from the table tablecomparisonCriteriacountOrCondition
Table.Min Obtains the row which has smallest value tablecomparisonCriteriadefault
Table.MinN Returns the N minimum value from the table tablecomparisonCriteriacountOrCondition
Table.FindText Obtains a specific text from the table tabletext
Table.ReplaceValue Replaces the old value in the specified columns of the table tableoldValuenewValuereplacercolumnsToSearch
Table.IsEmpty Inspect whether the given has any empty rows table
Table.SplitColumn Breaks specified column inset of additional column tablesourceColumnsplittercolumnNamesOrNumberdefault
Table.CombineColumns Amalgamates specified columns a new column tablesourceColumncombinercolumn
Table.FirstValue Returns first value of a column from the table else the value specifiied in the default parameter tabledefault
Table.Schema Returnss a table describing the columns of it table
Table.Profile Returns a profile for the columns in table tableadditionalAggregates
JoinKind.Inner Returns a table resulting from an inner join contains a row for each pair of rows
JoinKind.LeftOuter Ensure that all rows of the first table appear in the result
JoinKind.RightOuter Ensure that all rows of the first table appear in the result
JoinKind.FullOuter Ensure that all rows of both table appear in the result
JoinKind.LeftAnti Ensures all rows from the first table that does not have a match in the second table
JoinKind.RightAnti Ensures that all rows from the second table, does not have a match in the first table
ExtraValues.Error Raise an error if the splitter function ascertains more columns than the table expects
Table.FromValue Creates a table with a column valueOptions
Tables.GetRelationships Obtains relationships among a set of tables tablesdatacolumn
Table.FromColumns Generates table columns from the given Returnss of values listscolumns
Table.FromPartitions Combines a set of partitioned tables partitionColumnpartitionspartitionColumnType
Table.PartitionValues Returns the table based on the given column values tablecolumngroupshash
Table.FromRows Generatess a table from the provided the Returns of rows rowscolumns
Table.RowCount Returns the number of columns in a table table
Table.ToRecords Converts table inReturnss of records table
Table.FromRecords Converts Returnss of records intable recordscolumnsmissingField
Table.AddKey Adds a key table tablecolumnsisPrimary
Table.ReplaceKeys Replaces a keys from a table tablekeys
Table.First Obtains first row of the table table
Table.FirstN Obtains first row(s) of the table table
Table.Group Groups the rows tablekeyaggregatedColumnsgroupKindcomparer
Table.Join Joins the table rows table1key1table2key2joinKind
Table.AddJoinColumn Joins the table column table1key1table2key2newColumnname
Table.AddIndexColumn Adds index to the table tablenewColumnNameintialValueincrement
Table.FillDown Fills the null columns into the table tablecolumns
Table.TransformColumns Transforms the column specified tabletransfromOperationsdefaultTranformationmissingField
Table.TransformColumnTypes Transforms the column specified tabletypeTransformationsculture
Table.Sort Sorts the table tablecomparsionCriteria
Table.Distinct Obtains a distinct value tableequationCriteria
Table.ExpandRecordColumn Separates column for each field in the record tablecolumnfieldNamesnewColumnNames
Table.AggregateTableColumn Aggregates values into multiple column tablecolumnaggregations
Table.Combine Merge a list of tables tablecolumn
Table.Pivot Summaries of the table tablepivotValuesattributeColumnvalueColumnaggregationFunction
Table.Unpivot Unpivot the attribute-value pairs tablepivotValuesattributeColumnvalueColumn
Table.UnpivotOtherColumns Unpivot to all columns other than a specified set into the attribute-value pairs tablepivotValuesattributeColumnvalueColumn
Table.ReplaceErrorValues Replaces the error with value tableerrorReplacement
Table.Split Breaks the table into lists of the table tablepageSize
Table.Buffer Buffers a table in memory table
RowExpression.From Obtains AST for the function function
RowExpression.Row Obtains AST for the row
RowExpression.Column Creates AST represents access to column columnName ColumnName
ItemExpression.From Obtains AST for the function function
ItemExpression.Item Obtains AST for the row
Table.ViewFunction Returns View by table function

Text Function

Character.FromNumber Function Convertss the numerical values to a string value number
Character.ToNumber Function Convertss the numerical values to a string value character
Guid.From Function Identify the unique in a network that has many computers at many sites Value
Json.FromValue Function Exchange data between a server and web application Valueencoding
Text.AfterDelimiter Function Separate the text after the delimiter textdelimiterindex
Text.At Function Finds the exact position of the particular word textindex
Text.BeforeDelimiter Function Separate the text before the delimiter textdelimiterindex
Text.BetweenDelimiters Function Specified text from the entire text which is specified start Delimiter and end Delimiter textstartDelimiterendDelimiterstartIndexendIndex
Text.Clean Function Removes all non-printable characters from the given text value text
Text.Combine Function Combine the lists of words to single word textsseparator
Text.Contains Check any repeation of string textsubstringcomparer
Text.End Check any repeation of string textcount
Text.EndsWith whether text values end with the specified value substring textsubstringcomparer
Text.Format Separate text from the argument and string value formatstringargumentculture
Text.From Text representation value from any type format valueculture
Text.FromBinary Convertss data from binary format to text values format binaryencoding
Text.InferNumberType Returns the infer number type of the text textculture
Text.Insert Inserting new Text into the existing text value with the help of offset positions textoffsetnewText
Text.Length Returns the length of text text
Text.Lower Returns the text into Lower case textculture
Text.Middle Extract text from inside specific string textstartcount
Text.NewGuid Returns the new random Guid number
Text.PadEnd Returns text value padded to length count by inserting spaces at the end of the text value text textcountcharacter
Text.PadStart Returns text value padded to length count by inserting spaces at the Startof the text value text textcountcharacter
Text.PositionOf Returns specified position of the specified textvalue textsubstringOccurrencecomparer
Text.Split split text value from a cell textseperator
Text.SplitAny split text value from a cell textseperator
Text.Start Returns first characters from a text textcount
Text.StartsWith whether the text is starting with specified substring textsubstringcomparer
Text.ToBinary Converts text value to binary value textencodingincludebyteordermark
Text.ToList Converts text value to list text
Text.Trim Removes all leading and trailing whitespace from text value texttrim
Text.TrimEnd Removes all trailing whitespace from end of the text value texttrim
Text.TrimStart Removes all leading whitespace from start of the text value texttrim
Text.Upper Converts text to uppercase textculture
Text.PositionOfAny Returns position first occurrence of the character from the text value given by the user textcharacterOccurrence
Text.Proper Returns Capitalize the first letter in each text textculture
Text.Range Returns substring from the text with helps of offset textoffsetcount
Text.Remove Removes the unnecessary characters present in text values textremovechars
Text.RemoveRange Removes the character from the position of offset textoffsetcount
Text.Repeat Repeat text as specified textcount
Text.Replace Replaces text based on location textoldnew
Text.ReplaceRange Replaces text based on location textoffsetcountnewtext
Text.Reverse Returns the reverse value text
Text.Select Returns the characters without the special characters(#,@,!) textselectChars
RelativePosition.FromStart Indicates index to start from the beginning of the input
RelativePosition.FromEnd Indicates index to start from the end of the input.
TextEncoding.Utf8 To choose the UTF8
TextEncoding.Utf16 To choose UTF16
TextEncoding.Ascii To choose Ascii
TextEncoding.Unicode Unicodes little endian binary form
TextEncoding.BigEndianUnicode UTF big- endian binary form
TextEncoding.Windows Selects the Windows binary form

Time Function

Time.EndOfHour Obtains EndOfHour datetime
Time.From Returns the date-time from the given values valueculture
Time.FromText Converts the date values from the text textculture
Time.Hour Ascertain hour from the given time ,datetime datetime
Time.Minute Obtains minute for the given value datetime
Time.Second Obtains seconds from the time-value datetime
Time.StartOfHour Obtains first value of hour for the given time, Date-time value datetime
Time.ToRecord Converts DateTime value into records containing of date time values time
Time.ToText Obtains the text from the datetime timeformatculture
Time create a time value. hourminutesecond

Type Function

Type.TableSchema Describes the columns tabletype tableType
Type.ForRecord Identifies the type which represents records fieldsopen
Type.ForFunction Obtains the function type signaturemin
Type.NonNullable Identifies the non-nullable type type
Type.IsNullable Inspects weather the provided is type is nullable type
Type.ListItem Obtains the item type type
Type.OpenRecord Opens version from the provided record type type
Type.ClosedRecord Closes version from the provided record type type
Type.IsOpenRecord Identifies the provided record type is open type
Type.RecordFields Obtains name and value from the provided record type
Type.FunctionParameters Obtains name of the parameters type type
Type.FunctionRequiredParameters Indicates the minimum number to invoke the input type
Type.FunctionReturn Returns the type from the provided function type
Type.Union Obtains union of the types types
Type.Facets Obtains facets from the type(s) type
Type.ReplaceFacets Replaces the facets type
Type.TableColumn Obtains the type of the column typecolumn
Type.TableKeys Acquires empty list of keys tableType
Type.AddTableKey Adds a key typecolumnisPrimary
Type.ReplaceTableKeys Replaces the old tabletype with new table type tableTypekeys

Uri Function

Uri.Combine Combines URI baseUrirelativeuri
Uri.Parts Obtains the parts of absoluteUri absoluteUri
Uri.BuildQueryString Assembles the query into a URI query string query
Uri.EscapeDataString Encodes the special characters data

Value Function

Precision.Double Specifies double precision
Precision.Decimal Specifies decimal precision
Value.Equals Inspects provided value are equal value1value2Precision
Value.NullableEquals Inspects the provided argument is null value1value2Precision
Value.Compare Checks first value is less than, equal to, or greater than the second value value1value2Precision
Value.Type Obtains the type of the given value value
Value.RemoveMetadata Clears the metadata valuemetavalue
Value.ReplaceMetadata Replaces the input’s metadata valuemetavalue
Value.Metadata Contains the input’s metadata value
Value.FromText Obtains a value from the given text value textculture
Value.Add Adds the provided value value1value2Precision
Value.Subtract Subtracts the provided value value1value2Precision
Value.Multiply Multiplies the provided value value1value2Precision
Value.Divide Divides the provided value value1value2Precision
Value.NativeQuery Evaluates the query targetqueryparameteroptions
Embedded.Value Access the value valuepath