Forum Discussion
Unusual behavior from Table.FirstN
Hello, Im getting unusual behaviour from the Table.FirstN function please see image below, does nyone have any idea why The source is from sharepoint, which is the same as the other queries i...
I belive this is a known bug where doing a first N with 1 on some data sets that only have 1 value could return 2 results. You can try the following workarounds:
1. Get the first row of the table as a record with #"Previous step name"{0}?
2. Add the step before: Table.StopFolding(#"Previous Step")