Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 ?
Solved! Go to 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 👍
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 👍
User | Count |
---|---|
82 | |
77 | |
62 | |
60 | |
49 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |