Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Greg_Deckler

N-O Excel to DAX Translation

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