Generate Random Num from column to use not random number for another column

[Anonymous]

All Power BI Expert,

Eg, I generate Column A with Random Number, But for Column B, I want to copy and use that column A number as not a random number for column B

In Excel, we can copy and paste as a value.

Thank you for your help

[PiEye]

Hi @Anonymous  , can you elaborate more on what you are trying to do in PowerBI with the random numbers?

There is a RAND() function in DAX, if you apply this to  a measure you can then reference that same random number in other measures.

EG, we have the measures

A (random) = RAND()
B = [A (random)] +1

Results in the following:

You can see here that the figure in [A] persists, and is not generated again in [B]

I think it would help to understand what you are trying to achieve, though.

Pi