What is the best way to combine like tables ?

[EaglesTony]

Hi,

  I have 2 tables that are exactly alike in structure (i.e. same columns, types, etc), but 2 different sources of data (one for Q2 data and one for Q3 data).

  What would be the best way to combine them to create a 3rd table with all the rows from both tables ?

   My options I am thinking is in Power Query an "Append As New" and in DAX as a Union, but not sure of which one to use that would be more effective ?

[DOLEARY85 · Accepted solution]

Hi,

in terms of speed i'd go with Power Query as it will pe processed prior to any DAX measures and quives you a complete table ready for processing in report view.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍