Forum Discussion

bjoshi's avatar
bjoshi
Icon for Resolver I rankResolver I
9 years ago
Solved

Adding a new column with value from parameter

Hi,   I am trying to add a custom column which takes in value from a list parameter that has been created.  I am doing so using power query in advanced editor but not sure how to do it.   Exampl...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    On tab "Add Column" choose "Custom column".

    In New Column Name fill in OrgName.

    In Custom column formula fill in Org.

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
9 years ago

On tab "Add Column" choose "Custom column".

In New Column Name fill in OrgName.

In Custom column formula fill in Org.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Is there a way to use a named range from an Excel spreadsheet to populate the parameter? Something similar to that described in the "List Dates using Start and End Date Parameters from Named Ranges" section in this Power Query Lists post?