Nov 08 2017
07:12 AM
- last edited on
Jul 12 2019
10:55 AM
by
TechCommunityAP
Nov 08 2017
07:12 AM
- last edited on
Jul 12 2019
10:55 AM
by
TechCommunityAP
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 ?
Nov 08 2017 07:25 AM
SolutionHi Kriss,
That could be like
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content][[Column1],[Column2]] in Source
Nov 08 2017 07:25 AM
SolutionHi Kriss,
That could be like
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content][[Column1],[Column2]] in Source