Forum Discussion
OscarSuarez10
7 years agoHelper III
Add column wiht different values
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 th...
parry2k
7 years agoSuper User
OscarSuarez10 use RANDBETWEEN function
- OscarSuarez107 years agoHelper III
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
- parry2k7 years agoSuper User
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
- OscarSuarez107 years agoHelper III
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