Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Relation Ships

Hey @all.   I have 3 different Excel tables with the same column names. Now I want to depict only as one column in Power BI.  I Currently use the Relationship-function, but it looks like : ...
Need Help
Tips and Tricks
az38's avatar
az38
Community Champion
6 years ago

hi Anonymous 

use UNION() function

like

New Table = UNION(
Table1, Table2, table3
)

https://docs.microsoft.com/en-us/dax/union-function-dax

pay attention to those notes:

  • The two tables must have the same number of columns.
  • Columns are combined by position in their respective tables.
  • The column names in the return table will match the column names in table_expression1.
  • Duplicate rows are retained.