Forum Discussion
me me e me
I didn't save the pbix file.
Just follow the steps in this video.
Really not sure why you would want to do that. There is a random number generator in Power Query:
https://msdn.microsoft.com/en-us/library/mt253346.aspx
DAX also has a random number generator.
Thanks for your response.
in Power Query it doesnt work, and it generates same numbers. and also I want to generate between 2 Numbers like: 1000 and 3000
Random number generators give you a number between 0 and 1. So if you wanted something thats between 1000 to 3000, you simply need to multiply the random number by 2000 and then add 1000 to the result. Lastly just round to shave of the remaining decimals.
You can add a dummy column with zeroes and add this to the lower limit of Number.RandomBetween, which forces different values on each row.
Unlike Excel's RANDBETWEEN,, Number.RandomBetween returns fractions, so you need to round and also correct the upper and lower with .5 to have the results evenly distributed.
I created a separate query Texts with the list of names.
let
Source = #table({"Index"},List.Zip({{1..100}})),
AddedZero = Table.AddColumn(Source, "Zero", each 0),
AddedRandomNumber = Table.AddColumn(AddedZero, "RandomNumber", each Number.Round(Number.RandomBetween([Zero]+999.5,200000.5),0,RoundingMode.TowardZero)),
AddedRandomText = Table.AddColumn(AddedRandomNumber, "RandomText", each Texts{Number.Round(Number.RandomBetween([Zero]-.5,-.5+List.Count(Texts)),0,RoundingMode.TowardZero)}),
RemovedZero = Table.RemoveColumns(AddedRandomText,{"Zero"})
in
RemovedZeroThanks for your response
is it possible to send me pbix file?
i couldnt run the code you create.