Forum Discussion

nh27's avatar
nh27
Helper III
2 years ago
Solved

Use DAX to create a table

I have 7 tables that are all connected via one to many and many to many relationships, however I need a new table created just referencing specific columns from all these connected tables.   Is the...
Need Help
Show and Tell
  • amustafa's avatar
    amustafa
    2 years ago

    Not sure of the purpose but here's one way of doing it. For many-to-many relationships, you might need to use RELATEDTABLE and aggregate functions to correctly summarize the data.

     

    NewTable = SELECTCOLUMNS(
    Table1,
    "NewColumnA", Table1[ColumnA],
    "NewColumnB", RELATED(Table2[ColumnB]),
    "NewColumnC", RELATED(Table3[ColumnC]),
    ...
    )

     

amustafa's avatar
amustafa
Solution Sage
2 years ago

Not sure of the purpose but here's one way of doing it. For many-to-many relationships, you might need to use RELATEDTABLE and aggregate functions to correctly summarize the data.

 

NewTable = SELECTCOLUMNS(
Table1,
"NewColumnA", Table1[ColumnA],
"NewColumnB", RELATED(Table2[ColumnB]),
"NewColumnC", RELATED(Table3[ColumnC]),
...
)