PBI Hub文档
说明
日期和时间函数
DATE
DATEVALUE
DAY
EDATE
EOMONTH
HOUR
MINUTE
MONTH
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
YEAR
YEARFRAC
时间智能函数
CLOSINGBALANCEMONTH
CLOSINGBALANCEQUARTER
CLOSINGBALANCEYEAR
DATEADD
DATESBETWEEN
DATESINPERIOD
DATESMTD
DATESQTD
DATESYTD
ENDOFMONTH
ENDOFQUARTER
ENDOFYEAR
FIRSTDATE
FIRSTNONBLANK
LASTDATE
LASTNONBLANK
NEXTDAY
NEXTMONTH
NEXTQUARTER
NEXTYEAR
OPENINGBALANCEMONTH
OPENINGBALANCEQUARTER
OPENINGBALANCEYEAR
PARALLELPERIOD
PREVIOUSDAY
PREVIOUSMONTH
PREVIOUSQUARTER
PREVIOUSYEAR
SAMEPERIODLASTYEAR
STARTOFMONTH
STARTOFQUARTER
STARTOFYEAR
TOTALMTD
TOTALQTD
TOTALYTD
筛选器函数
ALL
ALLEXCEPT
ALLNOBLANKROW
CALCULATE
CALCULATETABLE
DISTINCT
EARLIER
EARLIEST
FILTER
RELATED
RELATEDTABLE
VALUES
信息函数
ISBLANK
ISERROR
ISLOGICAL
ISNONTEXT
ISNUMBER
ISTEXT
逻辑函数
AND
FALSE
IF
IFERROR
NOT
OR
TRUE
数学和三角函数
ABS
CEILING
EXP
FACT
FLOOR
INT
ISO.CEILING
LN
LOG
LOG10
MOD
MROUND
PI
POWER
QUOTIENT
RAND
RANDBETWEEN
ROUND
ROUNDDOWN
ROUNDUP
SIGN
SQRT
SUM
SUMX
TRUNC
统计函数
AVERAGE
AVERAGEA
AVERAGEX
COUNT
COUNTA
COUNTAX
COUNTBLANK
COUNTROWS
COUNTX
MAX
MAXA
MAXX
MIN
MINA
MINX
文本函数
BLANK
CONCATENATE
EXACT
FIND
FIXED
FORMAT
LEFT
LEN
LOWER
MID
REPLACE
REPT
RIGHT
SEARCH
SUBSTITUTE
TRIM
UPPER
VALUE
Published by PBIHub
SQRT
SQRT
返回数字的平方根。
语法
SQRT(
<
number
>
)
参数
项
定义
number
您希望计算其平方根的数字、包含数字的列或者计算结果为数字的表达式。
返回值
小数。
注释
如果该数字为负数,则 SQRT 函数将返回一个错误。
示例
下面的公式将返回 5。
=SQRT(25)
results matching "
"
No results matching "
"