Forum Discussion
Merge tables in data view
- Hello experts, I have quite a few data sources and because of file size, no option to merge in edit query.
I had to create calculation based on each. So I created separate tables for each data source and added calculated columns with Dax in data view. So table1 for data source 1 ....,Same calculation in all the tables and each has 1 row only and 15 columns. Now I would like to merge them into one calculated table so that the data from table1 gets in row1, data from table2 into row2... how do I do that in data view?
any help?
thanks a lot
Anonymous - You can use DAX functions like UNION, NATURALINNERJOIN, etc. to merge tabes in DAX. But, would depend on exactly what you are trying to achieve.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
3 Replies
- amitchandak
Super User
Anonymous , not very clear, refer if these can help
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
- Greg_Deckler
Community Champion
Anonymous - You can use DAX functions like UNION, NATURALINNERJOIN, etc. to merge tabes in DAX. But, would depend on exactly what you are trying to achieve.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
