Results 1 to 3 of 3

Thread: Parameter change(not refresh)

  1. #1
    Seeker ExcelStarter's Avatar
    Join Date
    Jan 2018
    Posts
    19
    Articles
    0
    Excel Version
    2016

    Parameter change(not refresh)



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

    Click image for larger version. 

Name:	Snap12.jpg 
Views:	11 
Size:	86.0 KB 
ID:	9066

    Changing parameters and then loading does not automatically refresh them.
    Attached Files Attached Files
    Last edited by ExcelStarter; 2019-04-25 at 04:16 PM.

  2. #2
    Acolyte horseyride's Avatar
    Join Date
    Nov 2017
    Posts
    78
    Articles
    0
    Excel Version
    Office 365 Pro Plus 1708.8431.
    sample.xlsx

    Create a named range Table3 with Column header Parameter and the actual parameter below that; reference the value in Powerquery using Excel.CurrentWorkbook(){[Name="Table3"]}[Content]{0}[Parameter]

    Code:
    let Source = Excel.CurrentWorkbook(){[Name="List"]}[Content],
    ChangeType = Table.TransformColumnTypes(Source,{{"list", type text}}),
    Parameter = Excel.CurrentWorkbook(){[Name="Table3"]}[Content]{0}[Parameter],
    FilteredRows = Table.SelectRows(ChangeType, each (
    [list] = Parameter))
    in FilteredRows
    Last edited by horseyride; 2019-04-25 at 04:33 PM.

  3. #3
    Seeker ExcelStarter's Avatar
    Join Date
    Jan 2018
    Posts
    19
    Articles
    0
    Excel Version
    2016
    Thank you for your reply.

    Could you tell me why it is not refreshing?

Posting Permissions

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