Create table and add rows

Question

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

No, Table2

Yes, Table2

Yes, Table3

No, Table4

Yes, Table4

Any ideas of the syntax for this?

samsontruong · Accepted Answer

Hi&nbsp;lg01&nbsp;,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")
)&nbsp;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.&nbsp;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&nbsp;Connect with me on LinkedInCheck out my BlogGoing to the European Microsoft Fabric Community Conference? Check out my Session

Forum Discussion

Create table and add rows

2 Replies

Related content

Create rows from 2 tables

Create new table

Lakehouse Table Generate Create Table

Table Created with Field Parameters missing rows

Creating Date Tables