Forum Discussion

gvg's avatar
gvg
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Dynamic source table name in Power Query

Hi, I have two data sources as tables in my query list: tableA and tableB. I want to build another query (myQuery) that dynamically takes either tableA or tableB as source. I know how to use paramet...
Show and Tell
  • avatorl's avatar
    avatorl
    6 years ago

    gvg

    Source = Expression.Evaluate("Table" & parameter, #shared)
gvg's avatar
gvg
Icon for Post Prodigy rankPost Prodigy
6 years ago

OK. But then I am stuck with amending the code every time another table (tableC, etc.) arrives.

avatorl's avatar
avatorl
Icon for Impactful Individual rankImpactful Individual
6 years ago

gvg

Source = Expression.Evaluate("Table" & parameter, #shared)