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 :
 
There are 3 different Columns.
 
Could you help me ?

 

Need Help
Tips and Tricks

2 Replies

  • 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.

     

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago
    Hi,

    You can also use append or merge option under query editor to combine your tables.

    Don't forget to give thumbs up 👍and accept it as a solution if it helped you.