Forum Discussion

robdan's avatar
robdan
Frequent Visitor
2 years ago

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

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!

 

Need Help

5 Replies

  • Anand24's avatar
    Anand24
    Icon for Super User rankSuper User
    2 years ago

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

    • robdan's avatar
      robdan
      Frequent Visitor
      2 years ago

      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's avatar
        Anand24
        Icon for Super User rankSuper User
        2 years ago

        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.