In Power Query, is there any way to lead multiple statements with the same variable name?
Here is an example,
Basically, I want to import a table and make changes to it, without having to create a new "MyTable" string at the start of every line.
But if I try the above code, I get a "Duplicate Initializer" error.
Just wondering if there is a better way to write M code in a situation like this.
Here is an example,
Code:
let
MyTable = Access.Database(...)
MyTable = Table.SelectRows(MyTable, each [ColumnToFilter] = "FilterValue")
in
MyTable
Basically, I want to import a table and make changes to it, without having to create a new "MyTable" string at the start of every line.
But if I try the above code, I get a "Duplicate Initializer" error.
Just wondering if there is a better way to write M code in a situation like this.