Create table and add rows

[lg01]

I have several tables in my project and in all of them I have a column called "Approved?"  What I'd like to do is create a new table, add two columns, one called "Approved?" and the other called "Source". Then I'd like to add the data from the different tables to populate my new table. Once this new table is populated, it will look something like this:

Approved?, Source

Yes, Table1

No, Table1

Yes, Table1

Yes, Table2

Yes, Table2

No, Table2

Yes, Table2

Yes, Table3

Yes, Table3

No, Table4

Yes, Table4

Any ideas of the syntax for this?

[Rueen1941]

very detailed! thanks

[SamsonTruong · Accepted solution]

Hi @lg01 ,

This can be achieved with a DAX calculated table like so:

NewTable =
UNION(
    SELECTCOLUMNS(Table1, "Approved?", Table1[Approved?], "Source", "Table1"),
    SELECTCOLUMNS(Table2, "Approved?", Table2[Approved?], "Source", "Table2"),
    SELECTCOLUMNS(Table3, "Approved?", Table3[Approved?], "Source", "Table3"),
    SELECTCOLUMNS(Table4, "Approved?", Table4[Approved?], "Source", "Table4")
)

 
Before implementing this, make sure to replace the tables with your actual tables and add additional lines based on the number of tables you have. 

If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

Thanks,

Samson

Connect with me on LinkedIn

Check out my Blog

Going to the European Microsoft Fabric Community Conference? Check out my Session