Add column wiht different values

Question

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.

parry2k · Answer

OscarSuarez10 use&nbsp;RANDBETWEEN function

oscarsuarez10 · Answer

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&nbsp;

parry2k · Answer

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 · Answer

parry2k&nbsp;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 · Answer

OscarSuarez10 sorry not sure what you are looking for.&nbsp;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

Forum Discussion

Add column wiht different values

6 Replies

Related content

Change column values based on different column values

Date Different return wrong value

Splitting Column values

Check column for similar values

Assign different value based on other column's value