Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

can't filter Table.First in a custom column formula

I have two tables called "ModelParameters" and "ModelRun". I am trying to add a custom column to "ModelRun" that is single row in "ModelParameters". I am trying to filter "ModelParameters" using the column "Scenario" which is in "ModelParameters". When I use this for the custom column I don't get the correct record I only get the first record in "ModelParameters"

 

Table.First(ModelParameters, each [Scenario]=3)

 

How do I filter "ModelParameters"?

3 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    Try using this

    Table.SelectRows(ModelParameters, each [Scenario]=3)

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      4 years ago

      Yes this does solve the question I posted however it doesn't help me with my broader problem which was using a column in ModelRun to filter ModelParameters. So i have a column in ModelRun call ScenarioRun so when i use the following formula for a custom column in the query for ModelRun:

       

      Table.SelectRows(ModelParameters, each [Scenario]=[ScenarioRun])

       

      i get an errror that [ScenarioRun] can't be found.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Syndicate_Admin ,

     

     

    Such error usually caused by incorrect or non-existent column names. See the details:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.