cancel
Showing results for
Did you mean:

## L-M Excel to DAX Translation

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

 LARGE function LARGE Quick Measures Gallery LCM function LCM LEFT, LEFTB functions LEFT LEN, LENB functions LEN LINEST function LN function LN LOG function LOG LOG10 function LOG10 LOGEST function LOGINV function EXP([mean]+[stdev]*NORM.S.INV([probability])) LOGNORM.DIST function PDF = 1/([x]*[stdev]*SQRT(2*PI()))* EXP(-1*POWER((LN([x])-[mean]),2)/(2*POWER([stdev],2)))   CDF = NORM.S.DIST((LN([x]) - [mean])/[stdev],TRUE) LOGNORMDIST function PDF = 1/([x]*[stdev]*SQRT(2*PI()))* EXP(-1*POWER((LN([x])-[mean]),2)/(2*POWER([stdev],2)))   CDF = NORM.S.DIST((LN([x]) - [mean])/[stdev],TRUE) LOGNORM.INV function EXP([mean]+[stdev]*NORM.S.INV([probability])) LOOKUP function LOOKUPVALUE LOWER function LOWER MATCH function N/A MAX function MAX or MAXX MAXA function MAXA MAXIFS function MAXX(FILTER(... && ...)...) or CALCULATE(MAX(),FILTER(... && ...)) MDETERM function MDURATION function MDURATION or Macaulay Duration Quick Measures Gallery MEDIAN function MEDIAN or MEDIANX MID, MIDB functions MID MIN function MIN or MINX MINIFS function MINX(FILTER(... && ...)...) or CALCULATE(MIN(),FILTER(... && ...)) MINA function MINA MINUTE function MINUTE MINVERSE function MIRR function ``````MIRR = VAR __Table = 'Table' VAR __FRate = [Finance_rate] VAR __RRate = [Reinvestment_rate] VAR __MIRRNum = VAR __Max = MAXX(FILTER(__Table,[Value]>0),[Index]) VAR __Table = ADDCOLUMNS( FILTER(__Table,[Value]>0), "NPV",[Value] * POWER(1 + __RRate,__Max - [Index]) ) RETURN SUMX(__Table,[NPV]) VAR __MIRRDenom = VAR __Table = ADDCOLUMNS( FILTER(__Table,[Value]<0), "NPV",[Value]/POWER((1+__FRate),[Index]) ) RETURN SUMX(__Table,[NPV]) * (1+__FRate) RETURN POWER(-1 * __MIRRNum/__MIRRDenom,1/(COUNTROWS(__Table)-1)) - 1`````` MMULT function MMULT Quick Measures Gallery MOD function MOD MODE function Mode Single Column Quick Measures Gallery Mode Multi-Column Quick Measures Gallery MODE.MULT function Mode Single Column Quick Measures Gallery Mode Multi-Column Quick Measures Gallery MODE.SNGL function Mode Single Column Quick Measures Gallery Mode Multi-Column Quick Measures Gallery MONTH function MONTH MROUND function MROUND MULTINOMIAL function MULTINOMIAL Quick Measures Gallery MUNIT function MUNIT Quick Measures Gallery

Top Kudoed Posts
Latest Articles
Archives
Polls
What is your favorite Power BI Feature release in July 2021?