返回主页
说明
聚合函数
聚合函数概述
APPROXIMATEDISTINCTCOUNT
AVERAGE
AVERAGEA
AVERAGEX
COUNT
COUNTA
COUNTAX
COUNTBLANK
COUNTROWS
COUNTX
DISTINCTCOUNT
DISTINCTCOUNTNOBLANK
MAX
MAXA
MAXX
MIN
MINA
MINX
产品
PRODUCTX
SUM
SUMX
日期和时间函数
日期和时间函数概述
CALENDAR
CALENDARAUTO
DATE
DATEDIFF
DATEVALUE
DAY
EDATE
EOMONTH
HOUR
MINUTE
MONTH
NOW
QUARTER
SECOND
TIME
TIMEVALUE
TODAY
UTCNOW
UTCTODAY
WEEKDAY
WEEKNUM
YEAR
YEARFRAC
筛选器函数
筛选器函数概述
ALL
ALLCROSSFILTERED
ALLEXCEPT
ALLNOBLANKROW
ALLSELECTED
CALCULATE
CALCULATETABLE
EARLIER
EARLIEST
FILTER
KEEPFILTERS
LOOKUPVALUE
REMOVEFILTERS
SELECTEDVALUE
财务函数
财务函数概述
ACCRINT
ACCRINTM
AMORDEGRC
AMORLINC
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
CUMIPMT
CUMPRINC
DB
DDB
DISC
DOLLARDE
DOLLARFR
DURATION
EFFECT
FV
INTRATE
IPMT
ISPMT
MDURATION
NOMINAL
NPER
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
PDURATION
PMT
PPMT
PRICE
PRICEDISC
PRICEMAT
PV
RATE
RECEIVED
RRI
SLN
SYD
TBILLEQ
TBILLPRICE
TBILLYIELD
VDB
XIRR
XNPV
YIELD
YIELDDISC
YIELDMAT
信息函数
信息函数概述
CONTAINS
CONTAINSROW
CONTAINSSTRING
CONTAINSSTRINGEXACT
CUSTOMDATA
HASONEFILTER
HASONEVALUE
ISAFTER
ISBLANK
ISCROSSFILTERED
ISEMPTY
ISERROR
ISEVEN
ISFILTERED
ISINSCOPE
ISLOGICAL
ISNONTEXT
ISNUMBER
ISODD
ISONORAFTER
ISSELECTEDMEASURE
ISSUBTOTAL
ISTEXT
NONVISUAL
SELECTEDMEASURE
SELECTEDMEASUREFORMATSTRING
SELECTEDMEASURENAME
USERNAME
USEROBJECTID
USERPRINCIPALNAME
逻辑函数
逻辑函数概述
AND
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
COALESCE
false
IF
IF.EAGER
IFERROR
NOT
OR
SWITCH
true
数学和三角函数
数学和三角函数概述
ABS
ACOS
ACOSH
ACOT
ACOTH
ASIN
ASINH
ATAN
ATANH
CEILING
CONVERT
COS
COSH
COT
COTH
CURRENCY
DEGREES
DIVIDE
EVEN
EXP
FACT
FLOOR
GCD
INT
ISO.CEILING
LCM
LN
LOG
LOG10
MOD
MROUND
ODD
PI
POWER
QUOTIENT
RADIANS
RAND
RANDBETWEEN
ROUND
ROUNDDOWN
ROUNDUP
SIGN
SIN
SINH
SQRT
SQRTPI
TAN
TANH
TRUNC
其他函数
其他函数概述
空白
ERROR
父函数和子函数
父函数和子函数概述
了解 父子层次结构的函数
PATH
PATHCONTAINS
PATHITEM
PATHITEMREVERSE
PATHLENGTH
关系函数
关系函数
CROSSFILTER
RELATED
RELATEDTABLE
USERELATIONSHIP
统计函数
统计函数概述
BETA.DIST
BETA.INV
CHISQ.DIST
CHISQ.DIST.RT
CHISQ.INV
CHISQ.INV.RT
COMBIN
COMBINA
CONFIDENCE.NORM
CONFIDENCE.T
EXPON.DIST
GEOMEAN
GEOMEANX
MEDIAN
MEDIANX
NORM.DIST
NORM.INV
NORM.S.DIST
NORM.S.INV
PERCENTILE.EXC
PERCENTILE.INC
PERCENTILEX.EXC
PERCENTILEX.INC
PERMUT
POISSON.DIST
RANK.EQ
RANKX
SAMPLE
STDEV.S
STDEV.P
STDEVX.S
STDEVX.P
T.DIST
T.DIST.2T
T.DIST.RT
T.INV
T.INV.2T
VAR.S
VAR.P
VARX.S
VARX.P
表操作函数
表操作函数概述
ADDCOLUMNS
ADDMISSINGITEMS
CROSSJOIN
CURRENTGROUP
DATATABLE
DETAILROWS
DISTINCT(列)
DISTINCT (table)
EXCEPT
FILTERS
GENERATE
GENERATEALL
GENERATESERIES
GROUPBY
IGNORE
INTERSECT
NATURALINNERJOIN
NATURALLEFTOUTERJOIN
ROLLUP
ROLLUPADDISUBTOTAL
ROLLUPGROUP
ROLLUPISUBTOTAL
ROW
SELECTCOLUMNS
SUBSTITUTEWITHINDEX
SUMMARIZE
SUMMARIZECOLUMNS
表构造函数
TOPN
TREATAS
UNION
VALUES
文本函数
文本函数概述
COMBINEVALUES
CONCATENATE
CONCATENATEX
EXACT
FIND
FIXED
FORMAT
LEFT
LEN
LOWER
MID
REPLACE
REPT
RIGHT
SEARCH
SUBSTITUTE
TRIM
UNICHAR
UNICODE
UPPER
值
时间智能函数
时间智能函数概述
CLOSINGBALANCEMONTH
CLOSINGBALANCEQUARTER
CLOSINGBALANCEYEAR
DATEADD
DATESBETWEEN
DATESINPERIOD
DATESMTD
DATESQTD
DATESYTD
ENDOFMONTH
ENDOFQUARTER
ENDOFYEAR
FIRSTDATE
FIRSTNONBLANK
FIRSTNONBLANKVALUE
LASTDATE
LASTNONBLANK
LASTNONBLANKVALUE
NEXTDAY
NEXTMONTH
NEXTQUARTER
NEXTYEAR
OPENINGBALANCEMONTH
OPENINGBALANCEQUARTER
OPENINGBALANCEYEAR
PARALLELPERIOD
PREVIOUSDAY
PREVIOUSMONTH
PREVIOUSQUARTER
PREVIOUSYEAR
SAMEPERIODLASTYEAR
STARTOFMONTH
STARTOFQUARTER
STARTOFYEAR
TOTALMTD
TOTALQTD
TOTALYTD
Published By Xifeng
其他函数
其他函数
这些函数执行无法定义为任何类别的唯一操作。
属于此类别的函数
函数
说明
BLANK
返回空白。
ERROR
引发错误并显示错误消息。
results matching "
"
No results matching "
"