Concatenating parameter to a table name

Question

I'm using the advanced editor to get many data tables.

One of the relevant lines in the editor looks like this (or similar)

powerbi_test_86035_meta_Table = templates_Schema{[Name="powerbi_test_86035_meta",Kind="Table"]}[Data]

I want to be able to replace the number in the middle (86035) with some kind of manual parameter, so when I change the parameter once, all the tables will update accordingly.

Is there a way to do this?

anonymous · Accepted Answer

nadavbi&nbsp;, create a parameter as TEXT, I've called it Parameter1 in this example.&nbsp;Add this M code to your query:&nbsp;PowerBI_Name_FromParameter = "powerbi_test_" &amp; Parameter1 &amp; "_meta",
Table_FromParameter =  templates_Schema{[Name=PowerBI_Name_FromParameter,Kind="Table"]}[Data]The first step simply concatenates the name using the Parameter1 valueThe second step passes the concatenated name in to return the proper table.

Forum Discussion

Concatenating parameter to a table name

2 Replies

Related content

Table Visuals Concatenate

create parameter from concatenation

Parameter Concatenation

Parameter table dimensions - summarize

Concatenate lists ;