Forum Discussion
Helper IITwo Tables of same Data
HI,
I have got Two tables of the Same Data (Same COlumns ), just the difference is between Past and Present Data.Each Table has about a million ROw,
is there any way alternative rather than Append, is it possible to build a Data model
I am sorry if my question doesn't make sense
4 Replies
- amitchandak
Super User
heygowtam , Create a common dimension and date table and join them with the common dimensions. They you can analyze data together , you can add measure from both tables in a measure to have data in one one measure
Refer to this, but this approach to create dimension is not suitable for your data size, bring it from the source
Hi heygowtam,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
heygowtamTable of same Data
Previous Year Data from _ DataBase
Current Year Data From - Sharepoint Folder
I just want treat them as single table without Appending it, is there any alternative than AppendHI heygowtam,
If they has the same data structure, you can create a new query table with Table.Combine funciton to reference and combine two table records. Then you can turn off the source query tables loading in query edit and only load the merged table records.
Table.Combine - PowerQuery M | Microsoft Learn
Regards,
Xiaoxin Sheng
