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.
Hi,
We have two tables created via DAX that we want to append to one table.
Because we created them via DAX we can't use Query Editor and we can't use UNION() because the order of columns is different. Newly created columns are added at the end of the first table and they need to be combined with columns at the beginning of the second table.
Any ideas on this?
Solved! Go to Solution.
Hey,
not sure if I understand your requirements correctly, if you want to append ROWS (the combined table gets longer) maybe
SELECTCOLUMS will be helpful https://msdn.microsoft.com/en-us/query-bi/dax/selectcolumns-function-dax
If you want to make your table wider (more columns) then you might consider
Maybe you also might consider to create sample data, upload a PBIX to onedrive or dropbox and share the link maybe with scribble visaulizing the expected result.
Regards,
Tom
@Anonymous
selectcoloumns should do
Hey,
not sure if I understand your requirements correctly, if you want to append ROWS (the combined table gets longer) maybe
SELECTCOLUMS will be helpful https://msdn.microsoft.com/en-us/query-bi/dax/selectcolumns-function-dax
If you want to make your table wider (more columns) then you might consider
Maybe you also might consider to create sample data, upload a PBIX to onedrive or dropbox and share the link maybe with scribble visaulizing the expected result.
Regards,
Tom
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |