Two Tables of same Data

[heygowtam]

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 

[heygowtam]

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

[Anonymous]

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

[Anonymous]

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

[amitchandak]

@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

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...