Combine the table together

[Chanleakna123]

hi all , i have material to connect all tables together , Brand is the master file , i wanna connect 2017 , 2018 , 2019 , 2020 together , i have used Measure : [ Related ( Column Name ) ] but it doesn't appear the Column name for me to select , i have connect the relationship together as well too. My purpose is to combine all these years together with the brand. 

[mussaenda]

If you are allowed in Power Query, you can append these tables. Just put a custom column for each table first before appending with corresponding year.

[Anonymous]

Hey @Chanleakna123 

Personally, I did not undersand you.

Better give sample data. Also provide the expected results.

Cheers!
A

[Chanleakna123]

hi , @Anonymous  , the result as per below 2nd tables , 

PS : i have used column = Relatedtable ( ) , but it doesn't connect to each other . 

2017 , 2018 , 2019 , is the calculated measure. and it is already happened. 

and how to acheived this as the combined talbes as per below . 

[Anonymous]

Hi @Chanleakna123 

One option is to use LOOKUPVALUE() DAX Function.

I am not sure what is the original data source, there might be better solutions.

LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>[, <search_columnName>, <search_value>]…[, <alternateResult>])   

Your tables need to be connected with Brand and Description columns.

Another option is to merge queries/tables.

Cheers!
A