Lijst met DAX-functies (PowerPivot)

Geplaatst in DAX-functies, Documentatie, Functies door Exhelp | Tags: , ,
Van toepassing op: Excel 2010, Excel 2013

powerpivotPowerPivot was tot op heden een niet aangesneden onderwerp op Exhelp.be. Bij deze brengen we daar verandering in, beginnende met een overzicht van alle DAX functies.

DAX (Data Analysis Expressions) is een formuletaal waarmee je aangepaste berekeningen kan definiëren in PowerPivot. DAX bevat een aantal functies die in Excel-formules worden gebruikt en extra functies die zijn ontworpen voor het werken met relationele gegevens en het uitvoeren van dynamische aggregatie.

In tegenstelling tot de ‘gewone’ Excel functies worden er in PowerPivot geen Nederlandstalige varianten voorzien voor DAX-functies. Deze bestaan dus enkel in het Engels.

Ben ik er ééntje vergeten? Laat het me weten!

TypeDAX-FunctieSyntaxOmschrijving (EN)
Wiskundige en trigonometrische functiesABS()ABS(< number >)Returns the absolute value of a number.
Statistische functiesADDCOLUMNS()ADDCOLUMNS(< table >, < name >, < expression >[, < name >, < expression >]…)Adds calculated columns to the given table or table expression.
FilterfunctiesALL()ALL(< table_or_column >)Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied.
FilterfunctiesALLEXCEPT()ALLEXCEPT(< table >, column1 >, < column2 >, …)Overrides all context filters in the table except filters that have been applied to the specified columns.
FilterfunctiesALLNOBLANKROW()ALLNOBLANKROW(< table >|< column >)Returns all the rows, except for blank rows, in a table or column, and disregards any context filters that might exist.
FilterfunctiesALLSELECTED()ALLSELECTED([< tableName > | < columnName >])Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.
Logische functiesAND()AND(< logical1 >, < logical2 >, …)Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE.
Statistische functiesAVERAGE()AVERAGE(< column >)Returns the average (arithmetic mean) of all the numbers in a column.
Statistische functiesAVERAGEA()AVERAGEA(< column >)Returns the average (arithmetic mean) of the values in a column. Handles text and non-numeric values.
Statistische functiesAVERAGEX()AVERAGEX(< table >, < expression >)Calculates the average (arithmetic mean) of a set of expressions evaluated over a table
FilterfunctiesBLANK()BLANK()Returns a blank.
FilterfunctiesCALCULATE()CALCULATE(< expression >, < filter1 >, < filter2 >…)Evaluates an expression in a context that is modified by the specified filters.
FilterfunctiesCALCULATETABLE()CALCULATETABLE( < expression >, < filter1 >, < filter2 >, …)Evaluates a table expression in a context modified by filters.
Wiskundige en trigonometrische functiesCEILING()CEILING(< number >, < significance >)Rounds a number up, to the nearest integer or to the nearest multiple of significance.
Functies voor tijdintelligentieCLOSINGBALANCEMONTH()CLOSINGBALANCEMONTH(< expression >, < dates >, < filter >)Evaluates the specified expression at the calendar end of the given month. The given month is calculated as the month of the latest date in the dates argument, after applying all filters.
Functies voor tijdintelligentieCLOSINGBALANCEQUARTER()CLOSINGBALANCEQUARTER(< expression >, < dates >, < filter >)Evaluates the specified expression at the calendar end of the given quarter. The given quarter is calculated as the quarter of the latest date in the dates argument, after applying all filters.
Functies voor tijdintelligentieCLOSINGBALANCEYEAR()CLOSINGBALANCEYEAR(< expression >, < dates >, < filter >)Evaluates the specified expression at the calendar end of the given year. The given year is calculated as the year of the latest date in the dates argument, after applying all filters.
TekstfunctiesCODE()CODE(< text >)Returns a numeric code for the first character in a text string, in the character set used by your computer.
TekstfunctiesCONCATENATE()CONCATENATE(< text1 >, < text2 >, …)Joins multiple text strings into one text string. The joined items can be text, numbers or Boolean values represented as text, or a combination of those items. You can also use a column reference if the column contains appropriate values.
InformatiefunctiesCONTAINS()CONTAINS(< table >, < columnName >, < value >[, < columnName >, < value >]…) Returns true if values for all referred columns exist, or are contained, in those columns; otherwise, the function returns false.
Statistische functiesCOUNT()COUNT(< column >)Counts the number of cells in a column that contain numbers.
Statistische functiesCOUNTA()COUNTA(< column >)Counts the number of cells in a column that are not empty.
Statistische functiesCOUNTAX()COUNTAX(< table >, < expression >)Counts nonblank results when evaluating the result of an expression over a table.
Statistische functiesCOUNTBLANK()COUNTBLANK(< column >)Counts the number of blank cells in a column.
Statistische functiesCOUNTROWS()COUNTROWS(< table >)Counts the number of rows in the specified table, or in a table defined by an expression.
Statistische functiesCOUNTX()COUNTX(< table >, < expression >)Counts the number of rows that contain a number or an expression that evaluates to a number, when evaluating an expression over a table.
Statistische functiesCROSSJOIN()CROSSJOIN(< table >, < table >[, < table >]…)Returns a table that contains the Cartesian product of all rows from all tables in the arguments. The columns in the new table are all the columns in all the argument tables.
Wiskundige en trigonometrische functiesCURRENCY()CURRENCY(< value >)Evaluates the argument and returns the result as currency data type.
Datum- en tijdfunctiesDATE()DATE(< year >, < month >, < day >)Returns the specified date in datetime format.
Functies voor tijdintelligentieDATEADD()DATEADD(< date_column >, < number_of_intervals >, < interval >)Returns a table that contains a column of dates, shifted either forward in time or back in time from the dates in the specified date column.
Functies voor tijdintelligentieDATESBETWEEN()DATESBETWEEN(< column >, < start_date >, < end_date >Returns a table of dates that can be found in the specified date column beginning with the start date and ending with the end date.
Functies voor tijdintelligentieDATESINPERIOD()DATESINPERIOD(< date_column >, < start_date >, < number_of_intervals >, < intervals >)Returns a table of dates that can be found in the specified date column beginning with the start date and continuing for the specified number of intervals.
Functies voor tijdintelligentieDATESMTD()DATESMTD(< date_column >)Returns the subset of dates, from date_column, for the interval that starts at the first day of the month and ends at the latest date in the specified dates column for the month that is the corresponding month of the latest date.
Functies voor tijdintelligentieDATESQTD ()DATESQTD (< date_column >)Returns the subset of dates, from date_column, for the interval that starts at the first day of the quarter and ends at the latest date in the specified dates column for the quarter that is the corresponding quarter of the latest date.
Functies voor tijdintelligentieDATESYTD ()DATESYTD (< date_column > [, < YE_date >])Returns the subset of dates, from date_column, for the interval that starts the first day of the year and ends at the latest date in the specified dates column for the quarter that is the corresponding quarter of the latest date.
Datum- en tijdfunctiesDATEVALUE()DATEVALUE(date_text)Converts a date in the form of text to a date in datetime format
Datum- en tijdfunctiesDAY()DAY(< date >)Returns the day of the month, a number from 1 to 31.
FilterfunctiesDISTINCT()DISTINCT(< column >)Returns a one-column table that contains the distinct values from the specified column.
Statistische functiesDISTINCTCOUNT()DISTINCTCOUNT(< column >)Counts the number of different cells in a column of numbers.
Wiskundige en trigonometrische functiesDIVIDE()DIVIDE(< numerator >, < denominator > [, < alternateresult >])Performs division and returns alternate result or BLANK() on division by 0.
FilterfunctiesEARLIER()EARLIER(< column >, < number >)Returns the current value of the specified column in an outer evaluation pass of the mentioned column.
FilterfunctiesEARLIEST()EARLIEST(< table_or_column >)Returns the current value of the specified column in an outer evaluation pass of the mentioned column
Datum- en tijdfunctiesEDATE()EDATE(< start_date >, < months >)Returns the date that is the indicated number of months before or after the start date. Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue
Functies voor tijdintelligentieENDOFMONTH()ENDOFMONTH(< date_column >)Returns the last day of the month in the specified date column.
Functies voor tijdintelligentieENDOFQUARTER()ENDOFQUARTER(< date_column >)Returns the last day of the quarter in the specified date column.
Functies voor tijdintelligentieENDOFYEAR()ENDOFYEAR(< date_column >)Returns the last day of the year in the specified date column.
Datum- en tijdfunctiesEOMONTH()EOMONTH(< start_date >, < months >)Returns the date in datetime format of the last day of the month, before or after a specified number of months. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.
TekstfunctiesEXACT()EXACT(< text1 >, < text2 >)Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. You can use EXACT to test text being entered into a document.
Wiskundige en trigonometrische functiesEXP()EXP(< number >)Returns e raised to the power of a given number. The constant e equals 2.71828182845904, the base of the natural logarithm.
Wiskundige en trigonometrische functiesFACT()FACT(< number >)Returns the factorial of a number, equal to the series 1*2*3*...* , ending in the given number.
Logische functiesFALSE()FALSE()Returns the logical value FALSE.
FilterfunctiesFILTER()FILTER(< table >, < filter >)Returns a table that represents a subset of another table or expression.
FilterfunctiesFILTERS()FILTERS(< columnName >)Returns a table that represents a subset of another table or expression.
TekstfunctiesFIND()FIND(< find_text, within_text, start_num)Returns the starting position of one text string within another text string. FIND is case-sensitive.
Functies voor tijdintelligentieFIRSTDATE ()FIRSTDATE (< datecolumn >)Returns the first date in the current context for the specified Date_Column.
Functies voor tijdintelligentieFIRSTNONBLANK()FIRSTNONBLANK(< column >, < expression >)Returns the first non-blank values in column, filtered by expression.
TekstfunctiesFIXED()FIXED(< number >, < decimals >, < no_commas >)Rounds a number to the specified number of decimals and returns the result as text. You can specify that the result be returned with or without commas.
Wiskundige en trigonometrische functiesFLOOR()FLOOR(< number >, < significance >)Rounds a number down, toward zero, to the nearest multiple of significance.
TekstfunctiesFORMAT()FORMAT(< value >, < format_string >)Converts a value to text according to the specified format.
Statistische functiesGENERATE()GENERATE(< table1 >, < table2 >)Returns a table with the Cartesian product between each row in table1 and the table that results from evaluating table2 in the context of the current row from table1.
Statistische functiesGENERATEALL()GENERATEALL(< table1 >, < table2 >)Returns a table with the Cartesian product between each row in table1 and the table that results from evaluating table2 in the context of the current row from table1.
FilterfunctiesHASONEFILTER()HASONEFILTER(< columnName >) Returns TRUE when the number of directly filtered values on columnName is one; otherwise returns FALSE.
FilterfunctiesHASONEVALUE()HASONEVALUE(< columnName >)Returns TRUE when the context for columnName has been filtered down to one distinct value only. Otherwise is FALSE.
Datum- en tijdfunctiesHOUR()HOUR(< datetime >)Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).
Logische functiesIF()IF(logical_test >, < value_if_true >, value_if_false)Checks if a condition provided as the first argument is met. Returns one value if the condition is TRUE, and returns another value if the condition is FALSE.
Logische functiesIFERROR()IFERROR(value, value_if_error)Returns value_if_error if the first expression is an error and the value of the expression itself if otherwise.
Wiskundige en trigonometrische functiesINT()INT(< number >)Rounds a number down to the nearest integer.
InformatiefunctiesISBLANK()ISBLANK(< value >)Checks whether a value is blank, and returns TRUE or FALSE.
FilterfunctiesISCROSSFILTERED()ISCROSSFILTERED(< columnName >)Returns TRUE when columnName or another column in the same or related table is being filtered.
InformatiefunctiesISERROR()ISERROR(< value >)Checks whether a value is an error, and returns TRUE or FALSE.
FilterfunctiesISFILTERED()ISFILTERED(< columnName >)Returns TRUE when columnName is being filtered directly. If there is no filter on the column or if the filtering happens because a different column in the same table or in a related table is being filtered then the function returns FALSE.
InformatiefunctiesISLOGICAL()ISLOGICAL(< value >)Checks whether a value is a logical value, (TRUE or FALSE), and returns TRUE or FALSE.
InformatiefunctiesISNONTEXT()ISNONTEXT(< value >)Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE.
InformatiefunctiesISNUMBER()ISNUMBER(< value >)Checks whether a value is a number, and returns TRUE or FALSE.
Wiskundige en trigonometrische functiesISO.CEILING()ISO.CEILING(< number >[, < significance >])Rounds a number up, to the nearest integer or to the nearest multiple of significance.
InformatiefunctiesISTEXT()ISTEXT(< value >)Checks whether a value is text, and returns TRUE or FALSE.
Functies voor tijdintelligentieLASTDATE ()LASTDATE (< datecolumn >)Returns the last date in the current context for the specified Date_Column.
Functies voor tijdintelligentieLASTNONBLANK ()LASTNONBLANK (< datecolumn >, < expression >)Returns the last value in the column, column, filtered by the current context, where the expression is not blank.
TekstfunctiesLEFT()LEFT(< text >, < num_chars >)Returns the specified number of characters from the start of a text string.
TekstfunctiesLEN()LEN(< text >)Returns the number of characters in a text string.
Wiskundige en trigonometrische functiesLN()LN(< number >)Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).
Wiskundige en trigonometrische functiesLOG()LOG(< number >, < base >)Returns the logarithm of a number to the base you specify.
Wiskundige en trigonometrische functiesLOG10()LOG10(< number >)Returns the base-10 logarithm of a number.
InformatiefunctiesLOOKUPVALUE()LOOKUPVALUE( < result_columnName >, < search_columnName >, < search_value >[, < search_columnName >, < search_value >]…)Returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value.
TekstfunctiesLOWER()LOWER(< text >)Converts all letters in a text string to lowercase.
Statistische functiesMAX()MAX(< column >)Returns the largest numeric value in a column.
Statistische functiesMAXA()MAXA(< column >)Returns the largest value in a column. Logical values and blanks are counted.
Statistische functiesMAXX()MAXX(< table >, < expression >)Evaluates an expression for each row of a table and returns the largest numeric value.
TekstfunctiesMID()MID(< text >, < start_num >, < num_chars >)Returns a string of characters from the middle of a text string, given a starting position and length.
Statistische functiesMIN()MIN(< column >)Returns the smallest numeric value in a column. Ignores logical values and text.
Statistische functiesMINA()MINA(< column >)Returns the smallest value in a column, including any logical values and numbers represented as text.
Datum- en tijdfunctiesMINUTE()MINUTE(< datetime >)Returns the minute as a number from 0 to 59, given a date and time value.
Statistische functiesMINX()MINX(< table >, < expression >)Returns the smallest numeric value that results from evaluating an expression for each row of a table.
Wiskundige en trigonometrische functiesMOD()MOD(< number >, < divisor >)Returns the remainder after a number is divided by a divisor. The result always has the same sign as the divisor.
Datum- en tijdfunctiesMONTH()MONTH(< datetime >)Returns the month as a number from 1 (January) to 12 (December).
Wiskundige en trigonometrische functiesMROUND()MROUND(< number >, < multiple >)Returns a number rounded to the desired multiple.
Functies voor tijdintelligentieNEXTDAY()NEXTDAY(< date_column >)Returns the next day date from date_column.
Functies voor tijdintelligentieNEXTMONTH()NEXTMONTH(< date_column >)Returns the set of dates in the next month from date_column.
Functies voor tijdintelligentieNEXTQUARTER ()NEXTQUARTER (< date_column >)Returns the set of dates for the next quarter from date_column
Functies voor tijdintelligentieNEXTYEAR()NEXTYEAR(< date_column >[, < YE_date >])Returns the set of dates for the next year from date_column.
Logische functiesNOT()NOT(< logical >)Changes FALSE to TRUE, or TRUE to FALSE.
Datum- en tijdfunctiesNOW()NOW()Returns the current date and time in datetime format.
Functies voor tijdintelligentieOPENINGBALANCEMONTH()OPENINGBALANCEMONTH(< expression >, < dates >, < filter >)Evaluates the specified expression at the calendar end of the month prior the given month. The given month is calculated as the month of the latest date in the dates argument, after applying all filters.
Functies voor tijdintelligentieOPENINGBALANCEQUARTER()OPENINGBALANCEQUARTER(< expression >, < dates >, < filter >)Evaluates the specified expression at the calendar end of the quarter prior to the given quarter. The given quarter is calculated as the quarter of the latest date in the dates argument, after applying all filters.
Functies voor tijdintelligentieOPENINGBALANCEYEAR()OPENINGBALANCEYEAR(< expression >, < dates >, < filter >)Evaluates the specified expression at the calendar end of the year prior to the given year. The given year is calculated as the year of the latest date in the dates argument, after applying all filters.
Logische functiesOR()OR(< logical1 >, < logical2 >, …)Checks whether one of the arguments is TRUE to return TRUE. The function returns FALSE if all arguments are FALSE
Functies voor tijdintelligentiePARALLELPERIOD()PARALLELPERIOD(< date_column >, < number_of_intervals >, < intervals >)This function moves the specified number of intervals and then returns all contiguous full months which contain any values after that shift. Gaps between the first and last dates are filled in, and months are also filled in.
InformatiefunctiesPATH()PATH(< ID_columnName >, < parent_columnName >)Returns a delimited text string with the identifiers of all the parents of the current identifier, starting with the oldest and continuing until current.
InformatiefunctiesPATHCONTAINS()PATHCONTAINS(< path >, < item >)Returns TRUE if the specified item exists within the specified path.
InformatiefunctiesPATHITEM()PATHITEM(< path >, < position >[, < type >])Returns the item at the specified position from a PATH() like result, counting from left to right.
InformatiefunctiesPATHITEMREVERSE()PATHITEMREVERSE(< path >, < position >[, < type >])Returns the item at position from a PATH() like function result, counting backwards from right to left.
InformatiefunctiesPATHLENGTH()PATHLENGTH(< path >)Returns the number of levels in a given PATH(), starting at current level until the oldest or top most parent level.
Wiskundige en trigonometrische functiesPI()PI()Returns the value of Pi, 3.14159265358979, accurate to 15 digits.
Wiskundige en trigonometrische functiesPOWER()POWER(< number >, < power >)Returns the result of a number raised to a power.
Functies voor tijdintelligentiePREVIOUSDAY()PREVIOUSDAY(< date_column >)Returns the previous day date from date_column.
Functies voor tijdintelligentiePREVIOUSMONTH()PREVIOUSMONTH(< date_column >)Returns the set of dates in the previous month from date_column.
Functies voor tijdintelligentiePREVIOUSQUARTER()PREVIOUSQUARTER(< date_column >)Returns the set of dates in the previous quarter from date_column.
Functies voor tijdintelligentiePREVIOUSYEAR()PREVIOUSYEAR(< date_column >)Returns the set of dates in the previous year from date_column.
Wiskundige en trigonometrische functiesQUOTIENT()QUOTIENT(< numerator >, < denominator >)Performs division and returns only the integer portion of the division result. Use this function when you want to discard the remainder of division.
Wiskundige en trigonometrische functiesRAND()RAND()Returns a random number greater than or equal to 0 and less than 1, evenly distributed. The number that is returned changes each time the cell containing this function is recalculated.
Wiskundige en trigonometrische functiesRANDBETWEEN()RANDBETWEEN(< bottom >, < top >)Returns a random number between the numbers you specify
Statistische functiesRANK.EQ()RANK.EQ(< value >, < columnName >[, < order >])Returns the ranking of a number in a list of numbers.
Statistische functiesRANKX()RANKX(< table >, < expression >[, < value >[, < order >[, < ties >]]][, < expression >[, < value >[, < order >[, < ties >]]]]…)
Returns the ranking of a number in a list of numbers for each row in the table argument.
FilterfunctiesRELATED()RELATED(< column >)Returns a related value from another table
FilterfunctiesRELATEDTABLE()RELATEDTABLE(< table >)Follows an existing relationship, in either direction, and returns a table that contains all matching rows from the specified table.
TekstfunctiesREPLACE()REPLACE(< old_text >, < start_num >, < num_chars >, < new_text >)Replaces part of a text string, based on the number of characters you specify, with a different text string.
TekstfunctiesREPT()REPT(< text >, < num_times >)Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string
TekstfunctiesRIGHT()RIGHT(< text >, < num_chars >)Returns the last character or characters in a text string, based on the number of characters you specify.
Wiskundige en trigonometrische functiesROUND()ROUND(< number >, < num_digits >)Rounds a number to the specified number of digits.
Wiskundige en trigonometrische functiesROUNDDOWN()ROUNDDOWN(< number >, < num_digits >)Rounds a number down, toward zero.
Wiskundige en trigonometrische functiesROUNDUP()ROUNDUP(< number >, < num_digits >)Rounds a number up, away from 0 (zero).
Statistische functiesROW()ROW(< name >, < expression >][, < name >, < expression >]…])
Returns a table with a single row containing values that result from the expressions given to each column.
Functies voor tijdintelligentieSAMEPERIODLASTYEAR()SAMEPERIODLASTYEAR(< dates >)Returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.
TekstfunctiesSEARCH()SEARCH(< search_text >, < within_text >, [start_num])Returns the number of the character at which a specific character or text string is first found, reading left to right. Search is case-sensitive.
Datum- en tijdfunctiesSECOND()SECOND(< time >)Returns the seconds of a time value, as a number from 0 to 59
Wiskundige en trigonometrische functiesSIGN()SIGN(< number >)Determines the sign of a number, the result of a calculation, or a value in a column. The function returns 1 if the number is positive, 0 (zero) if the number is zero, or -1 if the number is negative.
Wiskundige en trigonometrische functiesSQRT()SQRT(< number >)Returns the square root of a number.
Functies voor tijdintelligentieSTARTOFMONTH ()STARTOFMONTH (< date_column >)Returns the first day of the month in the specified date column.
Functies voor tijdintelligentieSTARTOFQUARTER ()STARTOFQUARTER (< date_column >)Returns the first day of the quarter in the specified date column.
Functies voor tijdintelligentieSTARTOFYEAR()STARTOFYEAR(< date_column >[, < YE_date >])Returns the first day of the year in the specified date column.
Statistische functiesSTDEV.P()STDEV.P(< ColumnName >)Returns the standard deviation of the entire population.
Statistische functiesSTDEV.S()STDEV.S(< ColumnName >)Returns the standard deviation of a sample population.
Statistische functiesSTDEVX.P()STDEVX.P(< table >, < expression >)Returns the standard deviation of the entire population.
Statistische functiesSTDEVX.S()STDEVX.S(< table >, < expression >)Returns the standard deviation of a sample population.
TekstfunctiesSUBSTITUTE()SUBSTITUTE(< text >, < old_text >, < new_text >, < instance_num >)Replaces existing text with new text in a text string.
Wiskundige en trigonometrische functiesSUM()SUM(< column >)Adds all the numbers in a column.
Statistische functiesSUMMARIZE()SUMMARIZE(< table >, < groupBy_columnName >[, < groupBy_columnName >]…[, < name >, < expression >]…)Returns a summary table for the requested totals over a set of groups.
Wiskundige en trigonometrische functiesSUMX()SUMX(< table >, < expression >)Returns the sum of an expression evaluated for each row in a table.
Logische functiesSWITCH()SWITCH(< expression >, < value >, < result >[, < value >, < result >]…[, < else >])Evaluates an expression against a list of values and returns one of multiple possible result expressions.
Datum- en tijdfunctiesTIME()TIME(hour, minute, second)Converts hours, minutes, and seconds given as numbers to a time in datetime format.
Datum- en tijdfunctiesTIMEVALUE()TIMEVALUE(time_text)Converts a time in text format to a time in datetime format.
Datum- en tijdfunctiesTODAY()TODAY()Returns the current date.
Statistische functiesTOPN()TOPN(< n_value >, < table >, < orderBy_expression >, [< order >[, < orderBy_expression >, [< order >]]…])Returns the top N rows of the specified table.
Functies voor tijdintelligentieTotalMTD()TotalMTD(< expression >, < dates >, < filter >)Evaluates the specified expression for the interval that starts at the first day of the month and ends at the latest date in the specified dates column, after applying all filters.
Functies voor tijdintelligentieTotalQTD()TotalQTD(< expression >, < dates >, < filter >)Evaluates the specified expression for the interval that starts at the first day of the quarter and ends at the latest date in the specified dates column, after applying all filters.
Functies voor tijdintelligentieTotalYTD()TotalYTD(< expression >, < dates >, < filter >)Evaluates the specified expression for the interval that starts at the first day of the year and ends at the latest date in the specified dates column, after applying all filters.
TekstfunctiesTRIM()TRIM(< text >)Removes all spaces from text except for single spaces between words.
Logische functiesTRUE()TRUE()Returns the logical value TRUE.
Wiskundige en trigonometrische functiesTRUNC()TRUNC(< number >, < num_digits >)Truncates a number to an integer by removing the decimal, or fractional, part of the number.
TekstfunctiesUPPER ()UPPER (< text >)Converts a text string to all uppercase letters
TekstfunctiesVALUE()VALUE(< text >)Converts a text string that represents a number to a number.
FilterfunctiesVALUES()VALUES(< column >)Returns a one-column table that contains the distinct values from the specified column. This function is similar to DISTINCT function, but VALUES function can also return Unknown member
Statistische functiesVAR.P()VAR.P(< columnName >)Returns the variance of the entire population.
Statistische functiesVAR.S()VAR.S(< columnName >) Returns the variance of a sample population.
Statistische functiesVARX.P()VARX.P(< table >, < expression >)Returns the variance of the entire population.
Statistische functiesVARX.S()VARX.S(< table >, < expression >)Returns the variance of a sample population.
Datum- en tijdfunctiesWEEKDAY()WEEKDAY(< date >, < return_type >)Returns a number from 1 to 7 identifying the day of the week of a date. By default the day ranges from 1 (Sunday) to 7 (Saturday).
Datum- en tijdfunctiesWEEKNUM()WEEKNUM(< date >, < return_type >)Returns the week number for the given date and year according to the specified convention. The week number indicates where the week falls numerically within a year.
Datum- en tijdfunctiesYEAR()YEAR(< date >)Returns the year of a date as a four digit integer in the range 1900-9999.
Datum- en tijdfunctiesYEARFRAC()YEARFRAC(< start_date >, < end_date >, < basis >)Calculates the fraction of the year represented by the number of whole days between two dates. Use the YEARFRAC worksheet function to identify the proportion of a whole year's benefits or obligations to assign to a specific term.
 

Plaats een reactie

U moet ingelogd zijn om te reageren.

Login

Forums

Exhelp

Meest recente berichten

TAGS



Creative Commons Licentie
Op dit werk is een Creative
Commons Licentie
van toepassing.