Forum Discussion
Need help combining multiple tables into one.
Hello, I need help in combining multiple tables into one. Below are my sample tables. I need to generate a new table like below. I need the 1st column to be the title of the table w...
Hi Anonymous ,
Please try to create a new table with below dax formula:
Table = VAR tmp1 = SELECTCOLUMNS ( Table1, "Table", "Table 1", "Name", [Name] ) VAR tmp2 = SELECTCOLUMNS ( Table2, "Table", "Table 2", "Name", [Name] ) VAR tmp3 = SELECTCOLUMNS ( Table3, "Table", "Table 3", "Name", [Name] ) RETURN UNION ( tmp1, tmp2, tmp3 )Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Once you import each table in Power Query, use Append Query as new option. See this video as a reference: How to COMBINE DATA with MERGE and APPEND in Power BI (youtube.com)
Thanks for the link. It really helped me.