Picture: Add a column: =Excel.Workbook([Content])
Source: link
Smart solution to a common problem.
Link
Insert BlankQuery: fnSWITCH()
(input) =>
let values = { {result_1, return_value_1}, {input, "Undefined"} },
Result = List.First(List.Select(values, each _{0}=input)){1}
in Result
Link
Alternating rows
Retreive Named ranges
= Excel.CurrentWorkbook() //finds all
= Excel.CurrentWorkbook(){[Name="MyRange"]}[Content]
= Files = Folder.Files(Source{0}[Column1]), // Single value
----
Undocumented
BI/Analytics training
