Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
lg01
Advocate II
Advocate II

Create table and add rows

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?

1 ACCEPTED SOLUTION
SamsonTruong
Solution Supplier
Solution Supplier

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

View solution in original post

1 REPLY 1
SamsonTruong
Solution Supplier
Solution Supplier

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

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.