Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @Thaung_Thaung , 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
I think it would help to understand what you are trying to achieve, though.
Pi
User | Count |
---|---|
106 | |
89 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |