Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
49 | |
42 | |
39 | |
38 |