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...
Need Help
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.

    • robdan's avatar
      robdan
      Frequent Visitor
      2 years ago

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

        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.