power bi常用函数大全汇总DAX函数

power bi常用函数大全汇总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
BETA.DIST	BETA.INV	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	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	IFERROR
IGNORE	INT	INTERSECT
INTRATE	IPMT	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
215.

LZ帖子不给力，勉强给回复下吧

纯粹路过，没任何兴趣，仅仅是看在老用户份上回复一下

看帖要回，回帖才健康，在踩踩，楼主辛苦了！

楼猪V5啊

谢谢网站确实不错，超值

大人，此事必有蹊跷！

打酱油的人拉，回复下赚取积分

呵呵，低调，低调！

支持，一直很喜欢老师的课程