This is part of a series of posts on Excel to DAX translation. The main article is here.
N function
|
CONVERT or VALUE
|
NA function
|
N/A
|
NEGBINOM.DIST function
|
NEGBINOM.DIST Quick Measures Gallery
|
NEGBINOMDIST function
|
NEGBINOM.DIST Quick Measures Gallery
|
NETWORKDAYS function
|
Net Work Days Quick Measures Gallery
|
NETWORKDAYS.INTL function
|
Net Work Days Quick Measures Gallery
|
NOMINAL function
|
NOMINAL or EFFECT Quick Measures Gallery
|
NORM.DIST function
|
NORM.DIST
|
NORMDIST function
|
NORM.DIST
|
NORMINV function
|
NORM.INV
|
NORM.INV function
|
NORM.INV
|
NORM.S.DIST function
|
NORM.S.DIST
|
NORMSDIST function
|
NORM.S.DIST
|
NORM.S.INV function
|
NORM.S.INV
|
NORMSINV function
|
NORM.S.INV
|
NOT function
|
NOT
|
NOW function
|
NOW
|
NPER function
|
NPER or
NPER =
VAR __type = 0
VAR __nper =
IF(
[rate] = 0,
-1 * ( ([PV] + [Fv]) ) / [pmt],
VAR __Table =
ADDCOLUMNS(
ADDCOLUMNS(
GENERATESERIES(1,10000,1),
"__nper1",POWER(1+[rate],-1*[Value]),
"__nper2",[rate]*[PV]/[pmt] + 1
),
"__diff",[__nper1] - [__nper2]
)
VAR __Min = MINX(FILTER(__Table,[__diff] >= 0),[__diff])
RETURN
MINX(FILTER(__Table,[__diff] = __Min),[Value])
)
RETURN
__nper
|
NPV function
|
Note, you need an Index column starting at 1
NPV =
VAR __Rate = [Rate]
VAR __Table =
ADDCOLUMNS(
'Table',
"NPV",[Value]/POWER((1+__Rate),[Index])
)
RETURN
SUMX(__Table,[NPV])
or XPNV
|
NUMBERVALUE function
|
VALUE
|
OCT2BIN function
|
DECIMAL and then DEC2BIN
|
OCT2DEC function
|
DECIMAL
|
OCT2HEX function
|
DECIMAL and then DEC2HEX
|
ODD function
|
ODD
|
ODDFPRICE function
|
ODDPRICE
|
ODDFYIELD function
|
ODDFYIELD
|
ODDLPRICE function
|
ODDLPRICE
|
ODDLYIELD function
|
ODDLYIELD
|
OFFSET function
|
N/A
|
OR function
|
OR
|