Syntax for referring to a Table indirectly as a Source

[chriswragge]

Hi there,

I have two tables. They both contain a list of data sources that my code loops through

1. Table_A for QA purposes and has a reduced set of sources. 
2. Table_B contains the full set of sources

Currently my setup is like so

let
    Source = Table_A,
    #"Added Custom" = Table.AddColumn(Source, "Custom", each myFunction_f([mySources])),

with me manually changing the value to Table_B when I am ready to push to production. However, I have a dozen or so queries that I am having to manually change. Ideally i would like to do this via a parameter which would allow me to toggle between Table_A and Table_B.

I have the below setup, but it's erroring out. How would I correctly do this?

Desired Code:

let
    Source = myParam,
    #"Added Custom" = Table.AddColumn(Source, "Custom", each myFunction_f([mySources])),

Error message when using 'Desired Code' 

[v-chuncz-msft · Accepted solution]

@chriswragge,

You may use Record.Field function.

    Source = Record.Field(#shared, myParam),