Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

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

Need Help
Tips and Tricks

1 Reply

  • PiEye's avatar
    PiEye
    Icon for Resolver II rankResolver II
    3 years ago

    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