Results 1 to 2 of 2

Thread: reference a cell's value in Power Query

  1. #1

    reference a cell's value in Power Query



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have named a cell in Excel 2010 "CurSelect" (derived from the selection made in a dropdown form control) - currently, the only two options from the dropdown are "Par Value" and "Market Value"

    When refreshing the table, the "Value" column (see formula below) always returns [MktVal] field data, regardless of whether "Par Value" or "Market Value" is selected from the dropdown. What am I missing?

    Thanks.


    = Table.AddColumn(#"Changed Type", "Value", each if fnGetValue = "Par Value" then [ParVal] else [MktVal])



    let fnGetValue=(CurSelect) =>
    let
    name = Excel.CurrentWorkbook(){[Name=CurSelect]}[Content],
    value = name{0}[Column1]
    in
    value
    in
    fnGetValue

  2. #2
    Excel 2010 with free Power Query Add-In,
    or Excel 2013 Pro Plus.
    ...Power Query can use data from the current workbook if the data is formatted as a Table.
    It cannot read data from individual cells or named ranges...
    Quoted from the book "Power Query for Power BI and Excel"
    by Chris Webb.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •