Forum Discussion
[Bug] Number.Random is not random.
Hi stenford23 ,
How about this approach? Use List.Random(1) to get random number, then use the Table.ExpandListColumn function to expand the list.
= Table.ExpandListColumn(Table.TransformColumns(grouped_table, {"random_number", each List.Random(1), type number}),"random_number")If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi stenford23 ,
How about this approach? Use List.Random(1) to get random number, then use the Table.ExpandListColumn function to expand the list.
= Table.ExpandListColumn(Table.TransformColumns(grouped_table, {"random_number", each List.Random(1), type number}),"random_number")
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-kkf-msft
yes that's perfect.
Why Number.Random isn't working but List.Random is working as expected?
Shouldn't both command be idempotent and return same generated number?
Both are calculated once.
