Forum Discussion
Help in Query Editor with the second argument of Table.FirstN using error criteria.
The 2nd parameter of Table.FirstN() needs to be an expression that evaluates to a whole number.
BUT, you can do something like this.
PreviousStep = //some M code here, Table_with_FirstN = Table.FirstN(PreviousStep, 20), Conditional = //some M code here that says whether or not to apply the FirstN transformation. FinalTable = if Conditional = true then Table_with_FirstN else PreviousStep in FinalTable
Thank you for the answer Chris!
What I liked in your anwer is the simplicity and brevity in the M code.
In following the brevity approach to the problem I've found that the 2nd parameter of Table.FirstN() can be any condition which evaluates to True/False. So, by trying to catch the error condition, I've came to the following solution:
//Using the "try ... otherwise" clause in M //A cell is equal to itself unless it contains an Error SingleStep = Table.FirstN(Table, each try [Column1] = [Column1] otherwise null <> null)
// ( try..otherwise error test )Greetings,
André
The 2nd parameter of Table.FirstN() needs to be an expression that evaluates to a whole number.
BUT, you can do something like this.
PreviousStep = //some M code here, Table_with_FirstN = Table.FirstN(PreviousStep, 20), Conditional = //some M code here that says whether or not to apply the FirstN transformation. FinalTable = if Conditional = true then Table_with_FirstN else PreviousStep in FinalTable
Thank you for the answer Chris!
What I liked in your anwer is the simplicity and brevity in the M code.
In following the brevity approach to the problem I've found that the 2nd parameter of Table.FirstN() can be any condition which evaluates to True/False. So, by trying to catch the error condition, I've came to the following solution:
//Using the "try ... otherwise" clause in M //A cell is equal to itself unless it contains an Error SingleStep = Table.FirstN(Table, each try [Column1] = [Column1] otherwise null <> null)
// ( try..otherwise error test )Greetings,
André