cancel
Showing results 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

## 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
Top Kudoed Posts
Latest Articles
Archives