cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
garrettmindrup
Frequent Visitor

Assign Random Number For Each Distinct Item

Hello, 

I have a table with document numbers and $ amounts. Some document numbers have multiple amounts, so those numbers repeat within the table. 
I'd like to assign random numbers to each distinct document number. Is there a way to do a FOREACH() type formula that will assign the RAND() function to each distinct value in my document number column? 

Example Output:

Rand()Doc Number$ Amount
.9921100
.992189
.87622000
.653341
.6533200
1 ACCEPTED SOLUTION
garrettmindrup
Frequent Visitor

I think my solution is to pull in the document numbers into a separate table, remove duplicates, assign random numbers, and then create a relationship between the distinct table and the table with duplicates. Still open to other ideas if someone has a better solution. 

View solution in original post

2 REPLIES 2
garrettmindrup
Frequent Visitor

I think my solution is to pull in the document numbers into a separate table, remove duplicates, assign random numbers, and then create a relationship between the distinct table and the table with duplicates. Still open to other ideas if someone has a better solution. 

garrettmindrup
Frequent Visitor

Bump

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors