Forum Discussion

Deleted

Nov 08, 2017

Solved

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 ?

BI & Data Analytics

Need Help

SergeiBaklan

Nov 08, 2017

Hi Kriss,

That could be like

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content][[Column1],[Column2]]
in
    Source

SergeiBaklan

Diamond Contributor

Nov 08, 2017

Hi Kriss,

That could be like

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content][[Column1],[Column2]]
in
    Source

Deleted

Nov 08, 2017

Hi Sergei,

Many thanks for your quick answer.