Power Query (M Code)

Function	Description	Documentation
Binary.Unzip	Extracts file from a compressed ZIP file	📄
DateTime.ToUnixTime	Converts a datetime format to Unix Time Stamp	📄
Decision.EntropyWeights	Calculates the weights of a decision multicriteria using the entropy weighting method	📄
Decision.TOPSIS	Applies the TOPSIS multicriteria method to a table in order to rank alternatives	📄
List.Correlation	Calculates the correlation coefficient between two lists of numeric values	📄
List.Intercept	Calculates the intercept B of the linear regression line Y = AX + B between two numerical lists X and Y	📄
List.Outliers	Returns a numerical list of outliers existing in a list	📄
List.PopulationStdDev	Calculates the population standard deviation of a numerical list	📄
List.Primes	Returns a list of prime numbers less than or equal to a given number n	📄
List.Rank	Returns a list of ranks for a given list of values	📄
List.Slope	Calculates the slope A of the linear regression Y = AX + B between two numerical lists X and Y	📄
List.Variance	Calculates the population variance of a numerical list	📄
List.WeightedAverage	Calculates the weighted average of a list of values given a corresponding list of weights	📄
Number.FromRoman	Converts a Roman numeral to a number	📄
Number.IsInteger	Checks if a number is integer or not	📄
Number.IsPrime	Checks if a number is prime or not	📄
Number.ToRoman	Converts a number to Roman numeral, if it's possible	📄
Statistical.NormDist	Calculates the Normal distribution for a given input x	📄
Statistical.NormInv	Returns the inverse of the CDF of the normal distribution	📄
Table.AddColumnFromList	Adds a new column to a table using values from a provided list	📄
Table.CorrelationMatrix	Calculates the correlation matrix for a given table	📄
Table.NormalizeColumnNames	Cleans and standardizes column names in a table	📄
Table.NormalizeTextColumns	Cleans, standardizes and formats column names in a table	📄
Table.NormalizeTextColumns	Cleans, standardizes and formats text columns in a table	📄
Table.RemoveBlankColumns	Removes columns from a table that contain only blank values	📄
Table.TransposeCorrectly	Transposes a table without losing the original column names	📄
Text.CountChar	Counts the occurrences of a specific character in a given text string	📄
Text.ExtractNumbers	Returns all numeric values from a given text	📄
Text.HtmlToPlainText	Converts HTML content to plain text	📄
Text.RegexExtract	Extracts a pattern from a text by using a regular expression	📄
Text.RegexReplace	Replaces a pattern in a text that match a given regular expression	📄
Text.RegexSplit	Splits a text into a list of strings based on a regular expression pattern	📄
Text.RegexTest	Tests whether a text matches a regular expression pattern	📄
Text.RemoveAccents	Removes any accent from characters in a text	📄
Text.RemoveDoubleSpaces	Replaces any sequence of multiple spaces in a text to sigle spaces	📄
Text.RemoveLetters	Removes all alphabetic characters from a text	📄
Text.RemoveNumerals	Removes all digits from a text	📄
Text.RemovePunctuations	Removes all punctuations from a text	📄
Text.RemoveStopwords	Removes common Portuguese stopwords from a text	📄
Text.RemoveWeirdChars	Removes special and non-printable characters from a text	📄