Randomly assigning a specific value to one of the rows

[smpa01]

Hi,

Aplogies if this has been posted previously by me. I tried posting it twice and I got an error message in both occassions. Please ignore if this is already a duplication.

I am trying to achieve a task which involves randomly assigining value "2" to one of the rows only. Is it possible to achieve in PBI/Power Query (DAX- not preferred). I have a column called "E Address". For each of the "E Address" I want PBI to assign a 2 to only one of the rows randomly and rest of the rows would be 1.

Data set - https://drive.google.com/open?id=1OD9wh3I3onjGaOjtXZInF5F7SExBwP4u

Thank you in advance.

[vega]

I don't believe that you can just change a value in PowerQuery from the dataset directly, for one row. You can replace a value in PowerQuery, but it will be all occurrences of a specific value. For example, you can say replace all instances of 0 in a specific column with the value 12.

[smpa01 · Accepted solution]

Find solution here - http://community.powerbi.com/t5/Desktop/Randomly-assiginng-a-specific-value-to-one-of-the-rows/m-p/3...