Create Union with filtered table names

[adrianal]

Hello, 

I'm have the following scenario:

A table where i stored all the filters i need (the table names where to get the data from, which filters to apply on which columns):

Now what i'm trying to do is to union this 2 tables from column "Origin Table" into a new table, but to get the names for the tables by filtering the table above, something like this:

New Table =

UNION(
         SELECTCOLUMNS(
                         Filter for the table name in the table above in column Origin Table => "Product",
                         I can deal with the filters on the columns )
        SELECTCOLUMNS(
                         Filter for the table name in the table above in column Origin Table => "Product",
                         I can deal with the filters on the columns )
        SELECTCOLUMNS(

                         Filter for the table name in the table above in column Origin Table => "Customer",
                         I can deal with the filters on the columns )
)

And the relsult expected is this one:

Is there a way to get the name of a table using filter in Union? If not, can you please help me with another solution to do this?

Hope i made myself clear in this explanation 

Thank you!!!

[v-stephen-msft]

Hi @adrianal ,

Can you provide me with sample data? Please be careful to hide private data.

Best Regards,

Stephen Tao

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

[lbendlin]

So you are basically creating your own query language?

Usually in such a case you have to help and provide the table names manually (add the table name as a static column in the SELECTCOLUMNS statement).

Or maybe vote for making EVALUATE() available in Power BI DAX.