Forum Discussion
Table.FirstN function doesn't seem to work properly for my case...
Hello, Here is my code for which I don't understand the output : let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("ndQ9bsMwDAXg3acQvDYWSOrP1lWCDBocJEVbF4085PaVOrSMHa...
Again, really ?? But that's crazy, after FirstN/LastN that give wrong results, now Distinct is not safe to use... Do you know where to find a list of those functions that produce "non-deterministic results" please ?
But for my need, it can take actually any row having the given id, because for all those lines, what I will need is in the table in the row called "Custom", and they have all the same content for each given Id.
I already included the link to the Power Query primer. Please take the time to go through that - it is time (very) well spent.