Forum Discussion

Chanleakna123's avatar
Chanleakna123
Icon for Post Prodigy rankPost Prodigy
7 years ago

Combine the table together

 

 

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. 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hey Chanleakna123 

    Personally, I did not undersand you.

    Better give sample data. Also provide the expected results.

    Cheers!
    A

    • Chanleakna123's avatar
      Chanleakna123
      Icon for Post Prodigy rankPost Prodigy
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        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

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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.