Add values from multiple columns from different tables to a new column

[Naz]

Is there any simple way to add values from two tables and create a new column? The tables have many-many relationship. Thanks

[v-chuncz-msft · Accepted solution]

@Naz 

You may take a look at the links below. 

• https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
• https://www.sqlbi.com/articles/lookup-multiple-values-in-dax/

[rajulshah]

Hello @Naz ,

It would be better if you can provide sample structure with dummy data.