Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Group, Merge or concatenate Table

I have to concatenate 4 tables.   Turn this Table: 2014 Column: ID, Year, Value Table: 2015 Column: ID, Year, Value Table: 2016 Column: ID, Year, Value Table: 2017 Column: ID, Year, Value ...
Need Help
Show and Tell
TalAruety's avatar
TalAruety
Advocate I
8 years ago

Hi Anonymous

Are you asking how to achieve this in SQL?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    No, in power bi

     

    Can I solve with append?

    Is it the better pratice?

     

    • TalAruety's avatar
      TalAruety
      Advocate I
      8 years ago

      I am not sure what are you aiming for then.

      Can you please eablorate?

       

      What  i understand is that you have 4 tables in powerbi model, and you want to union them into a single one using DAX?

      • BeemsC's avatar
        BeemsC
        Resolver III
        8 years ago

        Hey,

        You can Append as well as Merge using the query-editor ( See image)


        Alternatively you can use a DAX formula using the concatenate function.
        For more info on this function use this link: https://msdn.microsoft.com/en-us/library/ee634811.aspx

        Good luck