Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
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é
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |