RAND DAX Function (Math and Trig) Volatile
Returns a random number greater than or equal to 0 and less than 1, evenly distributed. Random numbers change on recalculation.
Syntax
RAND ( )
This expression has no parameters.
Return values
Scalar A single decimal value.
A random number.
» 1 related function
Examples
-- RAND returns a random number between 0 and 1
-- RANDBETWEEN returns a random number between
-- the two provide boundaries
DEFINE
VAR Vals = GENERATESERIES ( 1, 10, 1 )
VAR Random =
ADDCOLUMNS (
Vals,
"RAND", RAND (),
"RANDBETWEEN", RANDBETWEEN (-[Value], +[Value] )
)
EVALUATE
Random
EVALUATE
{
( "Random Average (around 0.5)", AVERAGEX ( Random, [RAND] ) ),
( "RandBetween Avg (near 0)", AVERAGEX ( Random, [RANDBETWEEN] ) ),
( "RandBetween Min (near -10000)", MINX ( Random, [RANDBETWEEN] ) ),
( "RandBetween Max (near 10000)", MAXX ( Random, [RANDBETWEEN] ) )
}
| Value | RAND | RANDBETWEEN |
|---|---|---|
| 1 | 0.31 | 0 |
| 2 | 0.87 | 2 |
| 3 | 0.54 | 0 |
| 4 | 0.91 | 1 |
| 5 | 0.24 | 3 |
| 6 | 0.40 | 2 |
| 7 | 0.39 | -6 |
| 8 | 0.40 | 6 |
| 9 | 0.99 | -6 |
| 10 | 0.41 | 1 |
| Value1 | Value2 |
|---|---|
| Random Average (around 0.5) | 0.55 |
| RandBetween Avg (near 0) | 0.30 |
| RandBetween Min (near -10000) | -6.00 |
| RandBetween Max (near 10000) | 6.00 |
Related articles
Learn more about RAND in the following articles:
-
Highlighting a data point and comparing to all others in a distribution
This article shows how you can highlight a single value in visual when comparing the distribution of a measure for one value versus all others. » Read more
Related functions
Other related functions are:
Last update: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/rand-function-dax
2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies