cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors