Forum Discussion
Select column from atable
Hi,
In the query editor I can load a "column 1" from "table 1" with this formula :
= Excel.CurrentWorkbook(){[Name="table 1"]}[Content][Column 1].
But is it a way to select more than 1 column ?
Hi Kriss,
That could be like
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content][[Column1],[Column2]] in Source
Hi Kriss,
That could be like
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content][[Column1],[Column2]] in Source
