Random With Duplicates

[Arul]

Hi All,

How can one will create the random numbers with duplicate in calculated column of Power BI?

Thanks,

-Arul

[v-robertq-msft · Accepted 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:

1. Create a calculated column:

Randon number between 1-15 = RANDBETWEEN(1,15)

2. Change the column type to the “Whole number”:

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.

[amitchandak]

@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 "

[Arul]

@amitchandak ,

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

[amitchandak]

@Arul , can you please share an example.