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

[Syndicate_Admin]

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"?

[Anonymous]

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.

[Vijay_A_Verma]

Try using this

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

[Syndicate_Admin]

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.