SSAS Functions

Below is a list of Analysis Services functions.

Function NameDescriptionParameter
ADDCALCULATEDMEMBERSReturns a set generated by adding calculated members to a specified set.«Set»
AGGREGATEReturns a calculated value using the appropriate aggregate function, based on the aggregation type of the member.«Set»[, «Numeric Expression»]
ALLMEMBERSReturns a set containing all members of the level, including calculated members.(none)
ALLMEMBERSReturns a set containing all members of the hierarchy, including calculated members.(none)
ANCESTORReturns the ancestor of a member at a specified level.«Member», «Level»
ANCESTORReturns the ancestor of a member at a specific distance away in the hierarchy.«Member», «Distance»
ANCESTORSReturns a set of all ancestors of a member at a specific distance above the member in the hierarchy.«Member», «Distance»
ANCESTORSReturns a set of all ancestors of a member at a specified level.«Member», «Level»
ASCENDANTSReturns the set of the ascendants of the member.«Member»
AVGReturns the average value of a numeric expression evaluated over a set.«Set»[, «Numeric Expression»]
AXISReturns a set defined in an axis.«Numeric Expression»
BOTTOMNCOUNTReturns a specified number of items from the bottom of a set, optionally sorting the set first.«Set», «Count»[, «Numeric Expression»]
BOTTOMPERCENTSorts a set and returns the specified number of bottommost elements whose cumulative total is at least a specified percentage.«Set», «Percentage», «Numeric Expression»
BOTTOMSUMSorts a set and returns the specified number of bottommost elements whose cumulative total is at least a specified value.«Set», «Value», «Numeric Expression»
CALCULATIONCURRENTPASSReturns the current calculation pass of a cube for the specified query context.(none)
CALCULATIONPASSVALUEReturns the value of a numeric MDX expression evaluated over the specified calculation pass of a cube.«Numeric Expression», «Pass Value»[[, «Access Flag»], ALL]
CHILDRENReturns the children of a member.(none)
CLOSINGPERIODReturns the last sibling among the descendants of a member at a specified level.[«Level»[, «Member»] ]
COALESCEEMPTYCoalesces an empty cell value to a number.«Numeric Expression»[, «Numeric Expression»…]
CORRELATIONReturns the correlation of two series evaluated over a set.«Set», «Numeric Expression»[, «Numeric Expression»]
DIMENSIONS.COUNTCounts the number of hierarchies in the cube.(none)
COUNTCounts the number of members in the tuple.(none)
COUNTCounts the number of tuples in the set.(none)
LEVELS.COUNTCounts the number of levels in the hierarchy.(none)
COUNTReturns the number of tuples in a set, optionally including or excluding empty tuples.«Set»[, EXCLUDEEMPTY | INCLUDEEMPTY]
COUSINReturns the child member with the same relative position under a parent member as the specified child member.«Member1», «Member2»
COVARIANCEReturns the covariance of two series evaluated over a set, using the biased population formula.«Set», «Numeric Expression»[, «Numeric Expression»]
COVARIANCENReturns the covariance of two series evaluated over a set, using the unbiased population formula.«Set», «Numeric Expression»[, «Numeric Expression»]
CROSSJOINReturns the cross product of two sets.«Set1», «Set2»
CURRENTReturns the current tuple from a set during an iteration.(none)
CURRENTMEMBERReturns the current member along a hierarchy(none)
CURRENTORDINALReturns the current ordinal during an iteration over a set(none)
CUSTOMDATAReturns the value of CustomData property(none)
DATAMEMBERReturns the system-generated data member associated with a nonleaf member.(none)
DEFAULTMEMBERReturns the default member of a hierarchy.(none)
DESCENDANTSReturns the set of descendants of a member at a specified level, optionally including or excluding descendants in other levels.«Member»[, «Level»[, «Desc_flags»]]
DESCENDANTSReturns the set of descendants of a member at a specific distance away in the hierarchy, optionally including or excluding descendants in other levels.«Member»,«Distance»[, «Desc_flags»]
DISTINCTReturns a set, removing duplicate tuples from a specified set.«Set»
DISTINCTCOUNTReturns the number of distinct tuples in a set.«Set»
DRILLDOWNLEVELDrills down the members of a set one level below the lowest level represented in the set, or to one level below an optional level of a member represented in the set.«Set»[, «Level» ]
DRILLDOWNLEVELDrills down the members of a set one level below the lowest level represented in the set, or to one level below a dimension optionally selected by its zero-based index of a member represented in the set.«Set»[, , «Index»]
DRILLDOWNLEVELBOTTOMDrills down the members of a specified count of bottom members of a set, at a specified level, to one level below.«Set», «Count»[, [«Level»][, «Numeric Expression»] ]
DRILLDOWNLEVELTOPDrills down a specified count of top members of a set, at a specified level, to one level below.«Set», «Count»[, [«Level»][, «Numeric Expression»] ]
DRILLDOWNMEMBERDrills down the members in a specified set that are present in a second specified set.«Set1», «Set2»[, RECURSIVE]
DRILLDOWNMEMBERBOTTOMDrills down the members in a specified set that are present in a second specified set, limiting the result set to a specified number of bottommost members.«Set1», «Set2», «Count»[, [«Numeric Expression»] [, RECURSIVE] ]
DRILLDOWNMEMBERTOPDrills down the members in a specified set that are present in a second specified set, limiting the result set to a specified number of topmost members.«Set1», «Set2», «Count»[, [«Numeric Expression»] [, RECURSIVE] ]
DRILLUPLEVELDrills up the members of a set that are below a specified level.«Set»[, «Level»]
DRILLUPMEMBERDrills up the members in a specified set that are present in a second specified set.«Set1», «Set2»
EXCEPTFinds the difference between two sets, optionally retaining duplicates.«Set1», «Set2»[, ALL]
EXISTING (none)
EXISTS «Set1», «Set2»
EXTRACTReturns a set of tuples from extracted dimension elements.«Set», «Dimension»[, «Dimension»…]
FILTERReturns the set resulting from filtering a set based on a search condition.«Set», «Search Condition»
FIRSTCHILDReturns the first child of a specified member.(none)
FIRSTSIBLINGReturns the first child of the parent of a specified member.(none)
GENERATEApplies a set to each member of another set and joins the resulting sets by union.«Set1», «Set2»[, ALL]
GENERATEReturns a concatenated string created by evaluating a string expression over a set.«Set», «String Expression»[, «Delimiter»]
HEADReturns the first specified number of elements in a set.«Set»[, «Numeric Expression»]
HIERARCHIZEOrders the members of a specified set in a hierarchy in natural or, optionally, post-natural order.«Set»[, POST]
HIERARCHYReturns the hierarchy of a specified level.(none)
HIERARCHYReturns the hierarchy of a specified dimension.(none)
IIFReturns one of values determined by a logical test.«Logical Expression», «object»,  «object»
INTERSECTReturns the intersection of two sets, optionally retaining duplicates.«Set1», «Set2»[, ALL]
ISReturns TRUE if two compared objects are equivalent, FALSE otherwise.(none)
ISANCESTORReturns TRUE if a specified member is an ancestor of another specified member, FALSE otherwise.«Member1»,«Member2»
ISEMPTYReturns TRUE if the evaluated expression is the empty cell value, FALSE otherwise.«Value Expression»
ISGENERATIONReturns TRUE if a specified member is in a specified generation, FALSE otherwise.«Member»,«Numeric Expression»
ISLEAFReturns TRUE if a specified member is a leaf member, FALSE otherwise.«Member»
ISSIBLINGReturns TRUE if a specified member is a sibling of another specified member, FALSE otherwise.«Member1»,«Member2»
ITEMReturns a member from a specified tuple.«Numeric Expression»
ITEMReturns a tuple from a specified set.«String Expression»[, «String Expression»…] | «Index»
KPICURRENTTIMEMEMBERReturns the current time member of the KPI«String Expression»
KPIGOALReturns the goal of the KPI.«String Expression»
KPISTATUSReturns the measure with normalized status between -1 and 1 of the KPI. «String Expression»
KPITRENDReturns the measure with normalized trend between -1 and 1 of the KPI«String Expression»
KPIVALUEReturns the measure with normalized value between -1 and 1 of the KPI«String Expression»
KPIWEIGHTReturns the measure with weight of the KPI«String Expression»
LAGReturns the member that is a specified number of positions prior to a specified member along the dimension of the member.«Numeric Expression»
LASTCHILDReturns the last child of a specified member.(none)
LASTPERIODSReturns a set of members prior to and including a specified member.«Index»[, «Member»]
LASTSIBLINGReturns the last child of the parent of a specified member.(none)
LEADReturns the member that is a specified number of positions following a specified member along the dimension of the member.«Numeric Expression»
LEVELReturns the level of a member.(none)
LEVELSReturns the level whose zero-based position in a dimension is specified by a numeric expression.«Numeric Expression»
LINKMEMBERReturns the member equivalent to a specified member in a specified hierarchy.«Member>, «Hierarchy»
LINREGINTERCEPTCalculates the linear regression of a set and returns the value of b in the regression line y = ax + b.«Set», «Numeric Expression»[, «Numeric Expression»]
LINREGPOINTCalculates the linear regression of a set and returns the value of y in the regression line y = ax + b.«Numeric Expression», «Set», «Numeric Expression»[, «Numeric Expression»]
LINREGR2Calculates the linear regression of a set and returns R² (the coefficient of determination).«Set», «Numeric Expression»[, «Numeric Expression»]
LINREGSLOPECalculates the linear regression of a set and returns the value of a in the regression line y = ax + b.«Set», «Numeric Expression»[, «Numeric Expression»]
LINREGVARIANCECalculates the linear regression of a set and returns the variance associated with the regression line y = ax + b.«Set», «Numeric Expression»[, «Numeric Expression»]
LOOKUPCUBEReturns the value of an MDX expression evaluated over another specified cube in the same database.«Cube Name», «Numeric Expression»
MAXReturns the maximum value of a numeric expression evaluated over a set.«Set»[, «Numeric Expression»]
MEASUREGROUPMEASURESReturns the set of measures in the measure group.«String Expression»
MEDIANReturns the median value of a numeric expression evaluated over a set.«Set»[, «Numeric Expression»]
MEMBERSReturns the set of all members in a specified hierarchy.(none)
MEMBERSReturns the set of all members at a specified level in a dimension.(none)
MEMBERTOSTRReturns a string in Multidimensional Expressions (MDX) format from a member.«Member»
MEMBERVALUEReturns the value of a member with its original data type.(none)
MINReturns the minimum value of a numeric expression evaluated over a set.«Set»[, «Numeric Expression»]
MTDReturns a set of members from the Month level in a Time dimension starting with the first period and ending with a specified member.[«Member»]
NAMEReturns the name of a specified member.(none)
NAMEReturns the name of a specified hierarchy.(none)
NAMEReturns the name of a specified level.Level
NAMETOSETReturns a set containing a single member based on a string expression containing a member name.«Member Name»
NEXTMEMBERReturns the next member in the level that contains a specified member.(none)
NONEMPTYReturns subset of first set with removed empty tuples based on the cross product with a second set.«Set1», «Set2»
NONEMPTYCROSSJOINReturns the cross product of two or more sets as a set, excluding empty members.«Set1», «Set2»[, «Set3»…][, «Crossjoin Count»]
OPENINGPERIODReturns the first sibling among the descendants of a specified level, optionally at a specified member.[«Level»[, «Member»] ]
ORDERArranges the members of a specified set, optionally preserving or breaking the hierarchy.«Set», {«String Expression» | «Numeric Expression»}[, ASC | DESC | BASC | BDESC]
ORDINALReturns the zero-based ordinal value associated with a specified level.(none)
PARALLELPERIODReturns a member from a prior period in the same relative position as a specified member.[«Level»[, «Numeric Expression»[, «Member»] ] ]
PARENTReturns the parent of a specified member.(none)
PERIODSTODATEReturns a set of members (periods) from a specified level starting with the first member and ending with a specified member.[«Level»[, «Member»] ]
PREDICTReturns a value of a numeric expression evaluated over a data mining model.«Mining Model Name», «Numeric Expression»
PREVMEMBERReturns the previous member in the level that contains a specified member.(none)
PROPERTIESReturns a string containing the value of the specified member property.«String Expression»[, TYPED]
QTDReturns a set of members from the Quarter level in a Time dimension starting with the first period and ending with a specified member.[«Member»]
RANKReturns the one-based rank of a specified tuple in a specified set.«Tuple», «Set»
ROLLUPCHILDRENReturns a value generated by rolling up the values of the children of a specified member using the specified unary operator.«Member», «String Expression»
SETTOARRAYConverts one or more sets to an array for use in a user-defined function.«Set»[, «Set»…][, «Numeric Expression»]
SETTOSTRConstructs a string in MDX format from a set.«Set»
SIBLINGSReturns the set of siblings of a specified member, including the member itself.(none)
STDDEVReturns the standard deviation of a numeric expression evaluated over a set, using an unbiased population. (Alias for Stdev.)«Set»[, «Numeric Expression»]
STDDEVPReturns the standard deviation of a numeric expression evaluated over a set, using a biased population. (Alias for StdevP.)«Set»[, «Numeric Expression»]
STDEVPReturns the standard deviation of a numeric expression evaluated over a set, using an unbiased population.«Set»[, «Numeric Expression»]
STDEVPReturns the standard deviation of a numeric expression evaluated over a set, using a biased population.«Set»[, «Numeric Expression»]
STRIPCALCULATEDMEMBERSReturns a set generated by removing calculated members from a specified set.«Set»
STRTOMEMBERReturns a member from a string expression in MDX format.«String Expression»
STRTOSETConstructs a set from a specified string expression in MDX format.«String Expression»
STRTOTUPLEConstructs a tuple from a specified string expression in MDX format.«String Expression»
STRTOVALUEReturns a value from a string expression.«String Expression»
SUBSETReturns a subset of members from a specified set.«Set», «Start»[, «Count»]
SUMReturns the sum of a numeric expression evaluated over a specified set.«Set»[, «Numeric Expression»]
TAILReturns a subset of members from the end of a specified set.«Set»[, «Count»]
TOGGLEDRILLSTATEToggles the drill state of members.«Set1», «Set2»[, RECURSIVE]
TOPCOUNTReturns a specified number of items from the topmost members of a specified set, optionally ordering the set first.«Set», «Count»[, «Numeric Expression»]
TOPPERCENTSorts a set and returns the topmost elements whose cumulative total is at least a specified percentage.«Set», «Percentage», «Numeric Expression»
TOPSUMSorts a set and returns the topmost elements whose cumulative total is at least a specified value.«Set», «Value», «Numeric Expression»
TUPLETOSTRReturns a string in MDX format from a specified tuple.«Tuple»
UNIONReturns a set generated by the union of two sets, optionally retaining duplicate members.«Set1», «Set2»[, ALL]
UNIQUENAMEReturns the unique name of a specified hierarchy.(none)
UNIQUENAMEReturns the unique name of a specified member.(none)
UNIQUENAMEReturns the unique name of a specified level.(none)
UNKNOWNMEMBERReturns the domain name and user name of the current connection.(none)
UNORDERReturns a set without ordering.«Set»
VALIDMEASUREReturns a value computed at the granularity of the measure group without unrelated dimensions and/or attributes.«Tuple»
VALUEReturns the value of a specified member.(none)
VARReturns the variance of a numeric expression evaluated over a set, using an unbiased population.«Set»[, «Numeric Expression»]
VARIANCEReturns the variance of a numeric expression evaluated over a set, using an unbiased population. (Alias for Var function.)«Set»[, «Numeric Expression»]
VARIANCEPReturns the variance of a numeric expression evaluated over a set, using a biased population. (Alias for VarP function.)«Set»[, «Numeric Expression»]
VARPReturns the variance of a numeric expression evaluated over a set, using a biased population.«Set»[, «Numeric Expression»]
VISUALTOTALSReturns a set generated by dynamically totaling child members in a specified set, optionally using a pattern for the name of the parent member in the result set.«Set», «Pattern»
WTDReturns a set of members from the Week level in a Time dimension starting with the first period and ending with a specified member.[«Member»]
YTDReturns a set of members from the Year level in a Time dimension starting with the first period and ending with a specified member.[«Member»]
DATEReturns the specified date in datetime format 
DATEVALUEConverts a date in the form of text to a date in datetime format 
DAYReturns a number from 1 to 31 representing the day of the month 
EDATEReturns the date that is the indicated number of months before or after the start date 
EOMONTHReturns the date in datetime format of the last day of the month before or after a specified number of months 
HOURReturns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.) 
MINUTEReturns a number from 0 to 59 representing the minute. 
MONTHReturns a number from 1 (January) to 12 (December) representing the month 
NOWReturns the current date and time in datetime format 
SECONDReturns a number from 0 to 59 representing the second 
TIMEConverts hours, minutes, and seconds given as numbers to a time in datetime format 
TIMEVALUEConverts a time in text format to a time in datetime format 
TODAYReturns the current date in datetime format 
WEEKDAYReturns a number from 1 to 7 identifying the day of the week of a date. 
WEEKNUMReturns the week number in the year 
YEARReturns the year of a date as a four digit integer 
YEARFRACReturns the year fraction representing the number of whole days between start_date and end_date 
ISBLANKChecks whether a value is blank, and returns TRUE or FALSE 
ISERRORChecks whether a value is an error, and returns TRUE or FALSE 
ISLOGICALChecks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE 
ISNONTEXTChecks whether a value is not text (blank cells are not text), and returns TRUE or FALSE 
ISNUMBERChecks whether a value is a number, and returns TRUE or FALSE 
ISTEXTChecks whether a value is text, and returns TRUE or FALSE 
ANDChecks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE 
FALSEReturns the logical value FALSE 
IFChecks whether a condition is met, and returns one value if TRUE, and another value if FALSE 
IFERRORReturns value_if_error if the first expression is an error and the value of the expression itself otherwise 
NOTChanges FALSE to TRUE, or TRUE to FALSE 
ORReturns TRUE if any of the arguments are TRUE, and returns FALSE if all arguments are FALSE 
TRUEReturns the logical value TRUE 
ABSReturns the absolute value of a number 
CEILINGRounds a number up, to the nearest integer or to the nearest unit of significance 
EXPReturns e raised to the power of a given number 
FACTReturns the factorial of a number, equal to 1*2*3*…* Number 
FLOORRounds a number down, toward zero, to the nearest multiple of significance 
INTRounds a number down to the nearest integer 
ISO.CEILINGRounds a number up, to the nearest integer or to the nearest multiple of significance 
LNReturns the natural logarithm of a number 
LOGReturns the logarithm of a number to the base you specify 
LOG10Returns the base-10 logarithm of a number 
MODReturns the remainder after a number is divided by a divisor 
MROUNDReturns a number rounded to the desired multiple 
PIReturns the value of Pi, 3.14159265358979, accurate to 15 digits 
POWERReturns the result of a number raised to a power 
QUOTIENTReturns the integer portion of a division 
RANDReturns a random number greater than or equal to 0 and less than 1, evenly distributed. Random numbers change on recalculation. 
RANDBETWEENReturns a random number between the numbers you specify 
ROUNDRounds a number to a specified number of digits 
ROUNDDOWNRounds a number down, toward zero 
ROUNDUPRounds a number up, away from zero 
SIGNReturns the sign of a number: 1 if the number is positive, zero if the number is zero, or -1 if the number is negative 
SQRTReturns the square root of a number 
TRUNCTruncates a number to an integer by removing the decimal, or fractional, part of the number 
BLANKreturns a blank 
CONCATENATEJoins two text strings into one text string 
EXACTChecks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive 
FINDReturns the starting position of one text string within another text string. FIND is case-sensitive 
FIXEDRounds a number to the specified number of decimals and returns the result as text with optional commas 
FORMATConverts a value to text in the specified number format 
LEFTReturns the specified number of characters from the start of a text string 
LENReturns the number of characters in a text string 
LOWERConverts all letters in a text string to lowercase 
MIDReturns a string of characters from the middle of a text string, given a starting position and length 
REPLACEReplaces part of a text string with a different text string 
REPTRepeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string 
RIGHTReturns the specified number of characters from the end of a text string 
SEARCHReturns the number of the character at which a specific character or text string is first found, reading left to right (not case-sensitive) 
SUBSTITUTEReplaces existing text with new text in a text string 
TRIMRemoves all spaces from a text string except for single spaces between words 
UPPERConverts a text string to all uppercase letters 
VALUEConverts a text string that represents a number to a number 
CLOSINGBALANCEMONTHEvaluates the specified expression for the date corresponding to the end of the current month after applying specified filters 
CLOSINGBALANCEQUARTEREvaluates the specified expression for the date corresponding to the end of the current quarter after applying specified filters 
CLOSINGBALANCEYEAREvaluates the specified expression for the date corresponding to the end of the current year after applying specified filters 
DATEADDMoves the given set of dates by a specified interval 
DATESBETWEENReturns the dates between two given dates 
DATESINPERIODReturns the dates from the given period 
DATESMTDReturns a set of dates in the month up to current date 
DATESQTDReturns a set of dates in the quarter up to current date 
DATESYTDReturns a set of dates in the year up to current date 
ENDOFMONTHReturns the end of month 
ENDOFQUARTERReturns the end of quarter 
ENDOFYEARReturns the end of year 
FIRSTDATEReturns first non blank date 
FIRSTNONBLANKReturns first non blank value 
LASTDATEReturns last non blank date 
LASTNONBLANKReturns last non blank value 
NEXTDAYReturns a next day 
NEXTMONTHReturns a next month 
NEXTQUARTERReturns a next quarter 
NEXTYEARReturns a next year 
OPENINGBALANCEMONTHEvaluates the specified expression for the date corresponding to the end of the previous month after applying specified filters 
OPENINGBALANCEQUARTEREvaluates the specified expression for the date corresponding to the end of the previous quarter after applying specified filters 
OPENINGBALANCEYEAREvaluates the specified expression for the date corresponding to the end of the previous year after applying specified filters 
PARALLELPERIODReturns a parallel period of dates by the given set of dates and a specified interval 
PREVIOUSDAYReturns a previous day 
PREVIOUSMONTHReturns a previous month 
PREVIOUSQUARTERReturns a previous quarter 
PREVIOUSYEARReturns a previous year 
SAMEPERIODLASTYEARReturns a set of dates in the current selection from the previous year 
STARTOFMONTHReturns the start of month 
STARTOFQUARTERReturns the start of quarter 
STARTOFYEARReturns the start of year 
TOTALMTDEvaluates the specified expression over the interval which begins on the first of the month and ends with the last date in the specified date column after applying specified filters 
TOTALQTDEvaluates the specified expression over the interval which begins on the first day of the quarter and ends with the last date in the specified date column after applying specified filters 
TOTALYTDEvaluates the specified expression over the interval which begins on the first day of the year and ends with the last date in the specified date column after applying specified filters 
ALLReturns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied 
ALLEXCEPTReturns all the rows in a table except for those rows that are affected by the specified column filters 
ALLNOBLANKROWReturns all the rows except blank row in a table, or all the values in a column, ignoring any filters that might have been applied 
CALCULATEEvaluates an expression in a context modified by filters 
CALCULATETABLEEvaluates a table expression in a context modified by filters 
DISTINCTReturns a one column table that contains the distinct (unique) values in a column 
EARLIERReturns the value in the column prior to the specified number of table scans (default is 1) 
EARLIESTReturns the value in the column for the very first point at which there was a row context 
FILTERReturns a table that has been filtered 
RELATEDReturns a related value from another table 
RELATEDTABLEReturns the related tables filtered so that it only includes the related rows 
VALUESReturns a one column table that contains the distinct (unique) values in a column 
SUMAdds all the numbers in a column 
SUMXReturns the sum of an expression evaluated for each row in a table 
AVERAGEReturns the average (arithmetic mean) of all the numbers in a column 
AVERAGEAReturns the average (arithmetic mean) of all the values in a column 
AVERAGEXReturns the average (arithmetic mean) of all the numbers in a column 
COUNTCounts the numbers in a column 
COUNTACounts the number of values in a column 
COUNTAXCounts the number of values which result from evaluating an expression for each row of a table 
COUNTBLANKCounts the number of blanks in a column 
COUNTROWSCounts the number of rows in a table 
COUNTXCounts the number of values which result from evaluating an expression for each row of a table 
MAXReturns the largest numeric value in a column. Ignores logical values and text 
MAXAReturns the largest value in a column. Does not ignore logical values and text 
MAXXReturns the largest numeric value that results from evaluating an expression for each row of a table 
MINReturns the smallest numeric value in a column. Ignores logical values and text 
MINAReturns the smallest value in a column. Does not ignore logical values and text 
MINXReturns the smallest numeric value that results from evaluating an expression for each row of a table 
Scroll to Top