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
This expression has no parameters.
Return values
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 7, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/rand-function-dax