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
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

    • MarcelBeug's avatar
      MarcelBeug
      Community Champion
      8 years ago

      Or just combine the tables in Power Query (M):

       

      = #"2014"&#"2015"&#"2016"&#"2017"