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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Greg_Deckler

F-G Excel to DAX Translation

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

 

FACT function

FACT

FACTDOUBLE function

FACT

FALSE function

FALSE

F.DIST function

F.DIST Quick Measures Gallery

FDIST function

F.DIST Quick Measures Gallery

F.DIST.RT function

F.DIST Quick Measures Gallery

FILTER function

FILTER

FILTERXML function

N/A

FIND, FINDB functions

FIND

F.INV function

F.DIST Quick Measures Gallery

F.INV.RT function

F.DIST Quick Measures Gallery

FINV function

F.DIST Quick Measures Gallery

FISHER function

FISHER Quick Measures Gallery

FISHERINV function

DIVIDE(EXP(2*[y]) - 1,EXP(2*[y]) + 1)

FIXED function

FORMAT(...,"Fixed")

FLOOR function

FLOOR

FLOOR.MATH function

FLOOR

FLOOR.PRECISE function

FLOOR

FORECAST function

@Daniil 's Simple Linear Regression

FORECAST.ETS function

 

FORECAST.ETS.CONFINT function

 

FORECAST.ETS.SEASONALITY function

 

FORECAST.ETS.STAT function

 

FORECAST.LINEAR function

@Daniil 's Simple Linear Regression

FORMULATEXT function

N/A

FREQUENCY function

SUMMARIZE or GROUPBY

F.TEST function

 

FTEST function

 

FV function

FV or

FV = 
    VAR __type = 0
RETURN
    IF(
        [rate] = 0, -1 * ( ([pmt] * [nper]) + [PV] ),
        -1 * ( 
            ( [PV] * POWER(1+[rate],[nper])) + 
            [pmt] * (1+[rate]*__type) *
            DIVIDE( POWER(1+[rate],[nper])-1,[rate])
        )
    )

FVSCHEDULE function

 

GAMMA function

GAMMA Quick Measures Gallery

GAMMA.DIST function

GAMMA Quick Measures Gallery

GAMMADIST function

GAMMA Quick Measures Gallery

GAMMA.INV function

 

GAMMAINV function

 

GAMMALN function

GAMMA Quick Measures Gallery

GAMMALN.PRECISE function

GAMMA Quick Measures Gallery

GAUSS function

NORM.S.DIST(2,TRUE)-.5

GCD function

GCD

GEOMEAN function

GEOMEAN or GEOMEANX

GESTEP function

IF([Number] >= [Step],1,0)

GETPIVOTDATA function

N/A

GROWTH function