Expression Error Occured during Mutiple Transform Rows function in single step

[Aravinda]

When I Try to Remove First Row and last row in single step using Table.Transformrows Function it show as expression error as mentioned below

Expression.Error: We cannot convert a value of type List to type Function.
Details:
Value=[List]
Type=[Type]pression

Below Dax Function is used 

= Table.TransformRows(#"Changed Type",{{Table.RemoveFirstN(#"Changed Type",1)},{Table.RemoveLastN(#"Changed Type",1)}})

Kindly Suggest Is there Any other Solution in a way where we can do mutiple transform row/Columns operations in single step

[daircom · Accepted solution]

Hi @Aravinda ,

It is a power query M function, not a DAX function. That might help you googling it.

You can simply apply a function to remove the top row and then immedieately apply the function to remove the last row on the result. Without saving it as an additional step.
Use the below (the first 1 is the amount of top rows that are skipped, the second 1 is the amount of bottom rows that are skipped):

= Table.RemoveLastN(
Table.Skip(#"Changed Type", 1), 1
)

[Aravinda]

Thanks for correcting me for mentioning M Language as Dax Function.

Your suggested steps give me a desired answer.I Appreciate your time spent to answer my queries

[daircom]

@Aravinda , glad to be able to help! Great that it worked!

If you select my answer as a solution, then another person facing this problem can find it as well (Y)