没有合适的资源?快使用搜索试试~ 我知道了~
首页DAX(Data Analysis Expressions)教程英文 .pdf
DAX(Data Analysis Expressions)教程英文 .pdf
需积分: 45 16 下载量 183 浏览量
更新于2023-05-17
1
收藏 2.45MB PDF 举报
Learn DAX Overview Videos DAX functions DAX function reference overview New DAX functions Date and time functions Date and time functions overview
资源详情
资源推荐
ContentsContents
Data Analysis Expressions
(
DAX
)
Reference
Learn
DAX Overview
Videos
DAX functions
DAX function reference overview
New DAX functions
Date and time functions
Date and time functions overview
CALENDAR
CALENDARAUTO
DATE
DATEDIFF
DATEVALUE
DAY
EDATE
EOMONTH
HOUR
MINUTE
MONTH
NOW
SECOND
TIME
TIMEVALUE
TODAY
UTCNOW
UTCTODAY
WEEKDAY
WEEKNUM
YEAR
YEARFRAC
Time
-
intelligence functions
Time
-
intelligence functions overview
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
Filter functions
Filter functions overview
ADDMISSINGITEMS
ALL
ALLCROSSFILTERED
ALLEXCEPT
ALLNOBLANKROW
ALLSELECTED
CALCULATE
CALCULATETABLE
CROSSFILTER
DISTINCT
(
column
)
DISTINCT
(
table
)
EARLIER
EARLIEST
FILTER
FILTERS
HASONEFILTER
HASONEVALUE
ISCROSSFILTERED
ISFILTERED
KEEPFILTERS
RELATED
RELATEDTABLE
SELECTEDVALUE
SUBSTITUTEWITHINDEX
USERELATIONSHIP
VALUES
Information functions
Information functions overview
CONTAINS
CUSTOMDATA
IN Operator / CONTAINSROW function
ISBLANK
ISERROR
ISEVEN
ISINSCOPE
ISLOGICAL
ISNONTEXT
ISNUMBER
ISODD
ISONORAFTER
ISTEXT
LOOKUPVALUE
USERNAME
Logical functions
Logical functions overview
AND
False
IF
IFERROR
IN
NOT
OR
SWITCH
True
Math and trig functions
剩余520页未读,继续阅读
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功