Add column wiht different values

[OscarSuarez10]

Hi, I´m trying to add a new column but need to type different values to each row, How can I do it?

The thing is that power bi let me type one number and this number is going to be constant in all the rows, but I need different numbers for each row.

[Anonymous]

were you able to find solution? i am in similar situation

[parry2k]

@OscarSuarez10 use RANDBETWEEN function

[OscarSuarez10]

Sorry maybe I didn´t write clearly but I want to type directly in power bi different numbers for a column, using power query ... Create a new column which values aren´t in the main table 

[parry2k]

@OscarSuarez10 you can surely add new column with random values in PowerBI, the first method I mentioned was using DAX but if you want to use Power Query, you can use Number.Random function to add column

[OscarSuarez10]

@parry2k The thing is that I have a list of numbers that I want to add in a column, but power bi just let me put one number for all the rows in the column

[parry2k]

@OscarSuarez10 sorry not sure what you are looking for. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490