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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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
Impactful Individual
Impactful Individual

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
Impactful Individual
Impactful Individual

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

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.

June 2025 community update carousel

Fabric Community Update - June 2025

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