Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to append two user created tables? When I go to Edit Queries, I don't see my user created tables on the left hand side. Assuming because the tables weren't created via query, but via Modeling --> New Table.
I essentially need to join the data of my two new tables created in Power Bi.
Any help would be appreciated.
Yes, the tables created via "New Table" do not appear in "Edit Queries" window.
Are you talking about union or join tables? To union tables, there's a DAX function UNION. While to JOIN tables, there're functions CROSSJOIN,NATURALINNERJOIN,NATURALLEFTOUTERJOIN. However usually you don't have to use them if proper relationship is created among tables.
I'm talking about Joining tables.
I'm in a situation where I needed to join "New Tables". I'm using a different approach now though since this seems like a dead end. Thanks.
You can join "New Tables" in DAX with the functions mentioned. What difficulty in joining tables do you have so that you have to say a "dead end"?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |