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.
RADIANS |
|
RAND |
|
{ RAND or RANDBETWEEN } |
|
RANDBETWEEN |
|
RANK.EQ or RANKX |
|
RANK.EQ |
|
RANKX |
|
RATE or RATE = [pmt] / [PV] |
|
RECEIVED or [investment] / (1 - ( [discount] * ( ([maturity] - [settlement] ) * 1. ) / [days in year basis] ) ) |
|
N/A |
|
REPLACE |
|
REPT |
|
RIGHT |
|
ROUND |
|
ROUNDDOWN |
|
ROUNDUP |
|
N/A |
|
COUNTROWS |
|
RRI or RRI = POWER([Fv]/[Pv],1/[nper]) - 1 Excel documentation is wrong |
|
@Daniil 's Correlation Coefficient or the built-in Correlation coefficient quick measure |
|
N/A |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.