A-B Excel to DAX Translation

[Greg_Deckler]

This is part of a series of posts on Excel to DAX translation. The main article is here.

Function name	DAX
ABS function	ABS
ACCRINT function	ACCRINT
ACCRINTM function	ACCRINTM or [par] * [rate] * [Ratio] Ratio =  0 - DAYS360([issue],[settlement) / 360 1 -  ([settlement] - [issue]) * 1. / [Actual days in year] 2 -  ([settlement] - [issue]) * 1. / 360 3 -  ([settlement] - [issue]) * 1. / 365 4 -  DAYS360([issue],[settlement) / 360
ACOS function	ACOS
ACOSH function	ACOSH
ACOT function	ACOT
ACOTH function	ACOTH
AGGREGATE function	N/A
ADDRESS function	N/A
AMORDEGRC function	AMORDEGRC
AMORLINC function	AMORLINC
AND function	AND
ARABIC function	ARABIC Quick Measures Gallery
AREAS function	N/A
ASC function	N/A
ASIN function	ASIN
ASINH function	ASINH
ATAN function	ATAN
ATAN2 function	ATAN2 Quick Measure Gallery
ATANH function	ATANH
AVEDEV function	AVEDEV = VAR __Average = AVERAGEX('Table',[Column]) VAR __Table = ADDCOLUMNS( 'Table', "Dev",ABS([Column] - __Average) ) RETURN AVERAGEX(__Table,[Dev])
AVERAGE function	AVERAGE
AVERAGEA function	AVERAGEA
AVERAGEIF function	AVERAGEX(FILTER(...)...) or CALCULATE(AVERAGE(),FILTER(...))
AVERAGEIFS function	AVERAGEX(FILTER(... && ...)...) or CALCULATE(AVERAGE(),FILTER(... && ...))
BAHTTEXT function	N/A
BASE function	BASE Quick Measures Gallery
BESSELI function
BESSELJ function
BESSELK function
BESSELY function
BETADIST function	BETA.DIST
BETA.DIST function	BETA.DIST
BETAINV function	BETA.INV
BETA.INV function	BETA.INV
BIN2DEC function	BIN2DEC Quick Measures Gallery
BIN2HEX function	BIN2DEC Quick Measures Gallery and DEC2HEX Quick Measures Gallery
BIN2OCT function	BIN2DEC Quick Measures Gallery and DEC2OCT Quick Measures Gallery
BINOMDIST function	BINOM.DIST Quick Measures Gallery
BINOM.DIST function	BINOM.DIST Quick Measures Gallery
BINOM.DIST.RANGE function	BINOM.DIST Quick Measures Gallery
BINOM.INV function	BINOM.DIST Quick Measures Gallery
BITAND function	BITAND Quick Measures Gallery
BITLSHIFT function	BITLSHIFT Quick Measures Gallery
BITOR function	BITOR Quick Measures Gallery
BITRSHIFT function	BITRSHIFT Quick Measures Gallery
BITXOR function	BITXOR Quick Measures Gallery