Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Greg_Deckler

R Excel to DAX Translation

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

 

RADIANS function

RADIANS

RAND function

RAND

RANDARRAY function

{ RAND or RANDBETWEEN }

RANDBETWEEN function

RANDBETWEEN

RANK.AVG function

RANK.EQ or RANKX

RANK.EQ function

RANK.EQ

RANK function

RANKX

RATE function

RATE or RATE = [pmt] / [PV]

RECEIVED function

RECEIVED or

[investment] / (1 - ( [discount] * ( ([maturity] - [settlement] ) * 1. ) / [days in year basis] ) )

REGISTER.ID function

N/A

REPLACE, REPLACEB functions

REPLACE

REPT function

REPT

RIGHT, RIGHTB functions

RIGHT

ROMAN function

ROMAN Quick Measures Gallery

ROUND function

ROUND

ROUNDDOWN function

ROUNDDOWN

ROUNDUP function

ROUNDUP

ROW function

N/A

ROWS function

COUNTROWS

RRI function

RRI or

RRI = POWER([Fv]/[Pv],1/[nper]) - 1

Excel documentation is wrong

RSQ function

@Daniil 's Correlation Coefficient or the built-in Correlation coefficient quick measure

RTD function

N/A