Relation Ships

[Anonymous]

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 ?

[Tahreem24]

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.

[az38]

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.