Skip to content

Instantly share code, notes, and snippets.

@Msirkovsky

Msirkovsky/formula.txt

Last active December 28, 2016 09:13
Show Gist options
  • Save Msirkovsky/23a297e665ca3e28dc4ac67e9040688c to your computer and use it in GitHub Desktop.
Save Msirkovsky/23a297e665ca3e28dc4ac67e9040688c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
formula.txt
let GetValue=(rangeName) => 
let
  CellRange = Excel.CurrentWorkbook(){[Name=rangeName]}[Content],
  Value = CellRange{0}[Column1]
  in
  Value
in
let
SalesDate = GetValue("salesDateCell"),
  Source = OData.Feed("https://localhost/web/odata/DataSalesForExcel?salesDate="&SalesDate)
in
 Source
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment