Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This is part of a series of posts on Excel to DAX translation. The main article is here.
LCM |
|
LEFT |
|
LEN |
|
|
|
LN |
|
LOG |
|
LOG10 |
|
|
|
EXP([mean]+[stdev]*NORM.S.INV([probability]))
|
|
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) |
|
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) |
|
EXP([mean]+[stdev]*NORM.S.INV([probability])) |
|
LOOKUPVALUE |
|
LOWER |
|
N/A |
|
MAX or MAXX |
|
MAXA |
|
MAXX(FILTER(... && ...)...) or CALCULATE(MAX(),FILTER(... && ...)) |
|
|
|
MDURATION or Macaulay Duration Quick Measures Gallery |
|
MEDIAN or MEDIANX |
|
MID |
|
MIN or MINX |
|
MINX(FILTER(... && ...)...) or CALCULATE(MIN(),FILTER(... && ...)) |
|
MINA |
|
MINUTE |
|
|
|
|
|
MOD |
|
MONTH |
|
MROUND |
|
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.