添加链接
注册
登录
link管理
链接快照平台
输入网页链接,自动生成快照
标签化管理网页链接
相关文章推荐
低调的回锅肉
·
跟不上全球升温的企鹅,会“灭绝”吗?|鸟类| ...
·
1 月前
·
睿智的小熊猫
·
【7月】天降女子!~女孩子从2楼…掉了下来! ...
·
1 月前
·
善良的筷子
·
金刚菩提最全的十问六看!你想知道的它都有!_ ...
·
4 月前
·
冷静的茶壶
·
云台二十八将介绍_汉程历史话题
·
4 月前
·
霸气的铅笔
·
多人联机打丧尸手游哪个好玩 ...
·
6 月前
·
link管理
›
SWITCH - DAX函数大全 - Power BI极客
dax
https://www.powerbigeek.com/dax-functions-switch/
乖乖的斑马
1 年前
扩展阅读:
理解 IF 和 SWITCH
IF 是最常见的逻辑函数,用于条件判断,它的语法和Excel相同。SWITCH是多层IF的简化形式,本质是IF嵌套,但是写法更优雅,本文将介绍两个函数在几个重要场景中的使用技巧
MSDN 文档:
SWITCH
DAX Guide:
SWITCH
DAX 圣经
知识体系
函数大全
DAX 函数大全
ABS
ACCRINT
ACCRINTM
ACOS
ACOSH
ACOT
ACOTH
ADDCOLUMNS
ADDMISSINGITEMS
ALL
ALLCROSSFILTERED
ALLEXCEPT
ALLNOBLANKROW
ALLSELECTED
AMORDEGRC
AMORLINC
AND
APPROXIMATEDISTINCTCOUNT
ASIN
ASINH
ATAN
ATANH
AVERAGE
AVERAGEA
AVERAGEX
BETA.DIST
BETA.INV
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
BLANK
CALCULATE
CALCULATETABLE
CALENDAR
CALENDARAUTO
CEILING
CHISQ.DIST
CHISQ.DIST.RT
CHISQ.INV
CHISQ.INV.RT
CLOSINGBALANCEMONTH
CLOSINGBALANCEQUARTER
CLOSINGBALANCEYEAR
COALESCE
COMBIN
COMBINA
COMBINEVALUES
CONCATENATE
CONCATENATEX
CONFIDENCE.NORM
CONFIDENCE.T
CONTAINS
CONTAINSROW 和 IN
CONTAINSSTRING
CONTAINSSTRINGEXACT
CONVERT
COS
COSH
COT
COTH
COUNT
COUNTA
COUNTAX
COUNTBLANK
COUNTROWS
COUNTX
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
CROSSFILTER
CROSSJOIN
CUMIPMT
CUMPRINC
CURRENCY
CURRENTGROUP
CUSTOMDATA
DATATABLE
DATE
DATEADD
DATEDIFF
DATESBETWEEN
DATESINPERIOD
DATESMTD
DATESQTD
DATESYTD
DATEVALUE
DAY
DB
DDB
DEGREES
DETAILROWS
DISC
DISTINCT
DISTINCTCOUNT
DISTINCTCOUNTNOBLANK
DIVIDE
DOLLARDE
DOLLARFR
DURATION
EARLIER
EARLIEST
EDATE
EFFECT
ENDOFMONTH
ENDOFQUARTER
ENDOFYEAR
EOMONTH
ERROR
EVEN
EXACT
EXCEPT
EXP
EXPON.DIST
FACT
FALSE
FILTER
FILTERS
FIND
FIRSTDATE
FIRSTNONBLANK
FIRSTNONBLANKVALUE
FIXED
FLOOR
FORMAT
FV
GCD
GENERATE
GENERATEALL
GENERATESERIES
GEOMEAN
GEOMEANX
GROUPBY
HASONEFILTER
HASONEVALUE
HOUR
IF
IF.EAGER
IFERROR
IGNORE
INT
INTERSECT
INTRATE
IPMT
ISAFTER
ISBLANK
ISCROSSFILTERED
ISEMPTY
ISERROR
ISEVEN
ISFILTERED
ISINSCOPE
ISLOGICAL
ISNONTEXT
ISNUMBER
ISO.CEILING
ISODD
ISONORAFTER
ISPMT
ISSELECTEDMEASURE
ISSUBTOTAL
ISTEXT
KEEPFILTERS
LASTDATE
LASTNONBLANK
LASTNONBLANKVALUE
LCM
LEFT
LEN
LN
LOG
LOG10
LOOKUPVALUE
LOWER
MAX
MAXA
MAXX
MDURATION
MEDIAN
MEDIANX
MID
MIN
MINA
MINUTE
MINX
MOD
MONTH
MROUND
NATURALINNERJOIN
NATURALLEFTOUTERJOIN
NEXTDAY
NEXTMONTH
NEXTQUARTER
NEXTYEAR
NOMINAL
NONVISUAL
NORM.DIST
NORM.INV
NORM.S.DIST
NORM.S.INV
NOT
NOW
NPER
ODD
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
OPENINGBALANCEMONTH
OPENINGBALANCEQUARTER
OPENINGBALANCEYEAR
OR
PARALLELPERIOD
PATH
PATHCONTAINS
PATHITEM
PATHITEMREVERSE
PATHLENGTH
PDURATION
PERCENTILE.EXC
PERCENTILE.INC
PERCENTILEX.EXC
PERCENTILEX.INC
PERMUT
PI
PMT
POISSON.DIST
POWER
PPMT
PREVIOUSDAY
PREVIOUSMONTH
PREVIOUSQUARTER
PREVIOUSYEAR
PRICE
PRICEDISC
PRICEMAT
PRODUCT
PRODUCTX
PV
QUARTER
QUOTIENT
RAND
RANDBETWEEN
RANK.EQ
RANKX
RATE
RECEIVED
RELATED
RELATEDTABLE
REMOVEFILTERS
REPLACE
REPT
RIGHT
ROLLUP
ROLLUPADDISSUBTOTAL
ROLLUPISSUBTOTAL
ROUND
ROUNDDOWN
ROUNDUP
ROW
SAMEPERIODLASTYEAR
SAMPLE
SEARCH
SECOND
SELECTCOLUMNS
SELECTEDMEASURE
SELECTEDMEASUREFORMATSTRING
SELECTEDMEASURENAME
SELECTEDVALUE
SIGN
SIN
SINH
SLN
SQRT
SQRTPI
STARTOFMONTH
STARTOFQUARTER
STARTOFYEAR
STDEV.P
STDEV.S
STDEVX.P
STDEVX.S
SUBSTITUTE
SUBSTITUTEWITHINDEX
SUM
SUMMARIZE
SUMMARIZECOLUMNS
SUMX
SWITCH
SYD
T.DIST
T.DIST.2T
T.DIST.RT
T.INV
T.INV.2T
TAN
TANH
TBILLEQ
TBILLPRICE
TBILLYIELD
TIME
TIMEVALUE
TODAY
TOPN
TOPNSKIP
TOTALMTD
TOTALQTD
TOTALYTD
TREATAS
TRIM
TRUE
TRUNC
UNICHAR
UNICODE
UNION
UPPER
USERELATIONSHIP
USERNAME
USEROBJECTID
USERPRINCIPALNAME
UTCNOW
UTCTODAY
VALUE
VALUES
VAR.P
VAR.S
VARX.P
VARX.S
VDB
WEEKDAY
WEEKNUM
XIRR
XNPV
YEAR
YEARFRAC
YIELD
YIELDDISC
YIELDMAT
DAX 查询
DEFINE(可选)
EVALUATE(必填)
ORDER BY(可选)
RETURN
START AT(可选)
VAR
DAX 运算符
不等于(<>)
且(&&)
严格相等(==)
包含(IN)
否定(NOT)
大于(>)
大于等于(>=)
小于(
小于等于(<=)
幂运算(^)
或(||)
相乘(*)
相减(-)
相加(+)
相等(=)
相除(/)
连接(&)
推荐文章
低调的回锅肉
·
跟不上全球升温的企鹅,会“灭绝”吗?|鸟类|阿德利|帝企鹅_网易订阅
1 月前
睿智的小熊猫
·
【7月】天降女子!~女孩子从2楼…掉了下来!?~_哔哩哔哩_bilibili
1 月前
善良的筷子
·
金刚菩提最全的十问六看!你想知道的它都有!_腾讯新闻
4 月前
冷静的茶壶
·
云台二十八将介绍_汉程历史话题
4 月前
霸气的铅笔
·
多人联机打丧尸手游哪个好玩 联机打丧尸游戏前五2023_九游手机游戏
6 月前