Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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?
Solved! Go to 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
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
82 | |
67 | |
61 | |
46 | |
45 |