F-G Excel to DAX Translation

[Greg_Deckler]

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