Forum Discussion
Solved
Custom Column Randbetween
I want to Create a Custom column ( Query Editor Environment) and generate random Numbers between for example 500 to 1000. I have tried this formula: Number.RandomBetween(500,1000) but it create...
I found the solution:
If i add Index Column the formula works correct.
Alternatively and similarly you can create a (temporary) column with the lower limit value in each row.
let
Source = Table.FromColumns({List.Numbers(500,20,0)},type table[NumberFrom = Int64.Type]),
#"Added Custom" = Table.AddColumn(Source, "Random", each Number.RandomBetween([NumberFrom],1000))
in
#"Added Custom"
