How to avoid duplicating tables when using "TABLE.COMBINE"

[robdan]

Hi,

I have the following model view: many excel tables (each one containing data for 1 month, for 1 or multiple countries e.g."AUSTRIA_CORP_2403") with customer data all merged togheter (via TABLE.COMBINE) into one main big table (e.g. "DB_CORP".

I would like to know if it is possible to avoid duplicating the data, by keeping only the "DB_CORP" table.

I can't use PowerQuery, since some of this data is coming by offline collections.

Thanks!

[Anand24]

@robdan ,
You can create a new calculated dax table using DISTINCT(DB_CORP). This table would return DB_CORP with only unique rows.

[robdan]

ciao @Anand24 , sorry maybe i didn't explain myself properly: i need DB_CORP to contain ALL rows from the multiple "single" tables. 
I was wondering if it is possible, when importing data, to import multiple excel at the same time and merge them togheter in the EDIT QUERY

[Anand24]

@robdan ,
You can simply append all the tables in Power Query Editor (Transform Data/Edit Queries). There is an option to append 3 or more tables which you can use. The only issue would be when new month's table comes up when you will have to perform this append again.

[robdan]

Do you mean the "Merge Queries" in the Home page of the edit query? That is what i'm using already by mergin as new.

My idea, in order to decrease the size of the report, would be to only keep the merged table 

[Anand24]

@robdan ,
Not merge queries. Merge is Table.NestedJoin while append is Table.Combine. You need to append the various tables. Make sure all tables have same table structures.