Power BI或者Excel中 DAX函数官当文档.pdf

Power

DAX函数

需积分: 49 38 下载量 10 浏览量更新于2023-03-03 评论 1 收藏 2.41MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

试读

510页

Power BI 或者Excel中使用DAX函数，这个文档是从官当下载的，有目录，方便大家快速学习，希望对大家学习Power BI 有帮助

资源详情

资源评论

资源推荐

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
 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
 Math and trig functions overview

 ABS
 ACOS
 ACOSH
 ASIN
 ASINH
 ATAN
 ATANH
 CEILING
 COMBIN
 COMBINA
 COS
 COSH
 CURRENCY
 DEGREES
 DIVIDE
 EVEN
 EXP
 FACT
 FLOOR
 GCD
 INT
 ISO.CEILING
 LCM
 LN
 LOG
 LOG10
 MOD
 MROUND
 ODD
 PI
 POWER
 PRODUCT