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

Do you get a blank result when you union the table giving you the issue with the others separately?:

Combined Table Test 1 = UNION(APAC,Americas)

Combined Table Test 2 = UNION(EMEA,Americas)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi.  Yes I do.  If I union the Americas with either of the other tables I get a blank, but union them together it's fine.  The issue appears to be with the Americas table.  When I look at the table in transform I see all the data.  When I save that and switch to table view I see nothing.

I've been to my excel file and checked the column formats, all seems to be OK.  I get the files delivered every month.  I went back to a previous file and that is still the same.  The spreadsheet is connected to external data sources (but then so are the others) so I disconnected it from those data sources.  Always the same. I see the data in the spreadsheet. I see the data in transform view, I don't see the data in the table view.