Hi PBPQ team,
I found a strange behavious which seems a bug to me.
Number.Random doesn't work in the correct way when used inside Table.Group or Table.TransformColumns.
- Expected behaviour:
Two table with column random_number containing different random value
- Real behaviour:
Two table with a column random_number containing the same value
Until the last update i never see this behaviour and Number.Random was working correctly.
The following link contains the sample pbix to reproduce the bug
2 Comments
Hi stenford23
The random columns of these two tables are regular columns. How did you get the different data? What is your data source?
Best Regards,
Community Support Team _ Ailsa TaoHi Anonymous
This is a sample dataset (hand made data) to reproduce the bug. I found this bug when working with excel file.
The table are generated in the following way:
- Grouped Random (generate a table with following value [1, 2, ..., 10])
let Source = #table(type table [Column = number], {{1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}}), grouped = Table.Group( Source, "Column", {{"random_number", each Number.Random(), type number}} ) in grouped- Transform Random (refers to previous dataset and apply a transformation):
let Source = Table.TransformColumns(grouped_table, {"random_number", each Number.Random(), type number}) in SourceIn both cases until last month i was able to generate random number inside Table.Group and Table.TransformColumns. Now it's not working anymore.
In the link you can find the pbix with the two queries.
https://www.dropbox.com/s/mwajc4k6od6vgjd/bug_random_number.pbix?dl=0
