Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Combine data from 3 different spreadsheets

I've seen some posts that nearly address my issue but not quite.  I receive 3 reports each month.  these come from 3 different finance teams that operate with 3 different systems.  This means the col...
Need Help
  • S_JB's avatar
    S_JB
    5 years ago

    You can combine the 3 tables by using a union. Go to the modelling tab, select new table and enter the logic below (the table names will need updating to what you have called them):

     

    Combined Table = UNION(Table 1,Table 2,Table 3)

     

    Please use the link below to learn more about the UNION function:

     

    https://docs.microsoft.com/en-us/dax/union-function-dax 

S_JB's avatar
S_JB
Resolver III
5 years ago

You can combine the 3 tables by using a union. Go to the modelling tab, select new table and enter the logic below (the table names will need updating to what you have called them):

 

Combined Table = UNION(Table 1,Table 2,Table 3)

 

Please use the link below to learn more about the UNION function:

 

https://docs.microsoft.com/en-us/dax/union-function-dax 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I think I'm getting there.  I've used transform data to get all spreadsheets the same by renaming columns, moving them, and deleting those that don't match.  All good so far.  See below.

Then I go to the modelling tab and add the logic.  All seems fine but the table is empty.  I have traced it to just one table.  If I delete that one from the logic the other two combine OK.  All the columns are the same type in all tables.  See below.

Any ideas?

 

Thanks