Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
How can one will create the random numbers with duplicate in calculated column of Power BI?
Thanks,
-Arul
Solved! Go to Solution.
Hi, @Arul
According to your description, you want to create a calculated column that can return the random numbers but also with duplicates sometimes, right? I think you can achieve this using the Randbetween() function in DAX, you can try my steps:
Randon number between 1-15 = RANDBETWEEN(1,15)
And you can get what you want.
You can download my test pbix file here
More info about the Randbetween() function in DAX
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Arul
According to your description, you want to create a calculated column that can return the random numbers but also with duplicates sometimes, right? I think you can achieve this using the Randbetween() function in DAX, you can try my steps:
Randon number between 1-15 = RANDBETWEEN(1,15)
And you can get what you want.
You can download my test pbix file here
More info about the Randbetween() function in DAX
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Arul , You can use rand and randbetween
Refer to my video: https://www.youtube.com/watch?v=LFAT7AEDk5Q
But not Sure on what you mean by "with duplicate in calculated column "
I have refered that Video but the duplicate values that DAX function genearting are giving me the same values. But, I want to see the duplicate values with different numbers not the same numbers.
Thanks,
-Arul
@Arul , can you please share an example.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |