Arithmetic across tables

[jteccampbell]

I have a workbook with seven worksheets; each worksheet represents the same information just pulled from a different source. Worksheet one (the goal) and is what I want to compair all the other worksheets (what actually happening) to.

I can make a table that brings in the data from the different worksheets but I can not make any visulaizations. Also, I can not make any realtionships in POWERBI.

I have tried converting the workbook from Excel to Access and creating the relationships in Access.

result: POWERBI will not import the data

I made a sample workbook of similar data to share here but I don't see an attachment link.

Can someone help please!

[v-yuezhe-msft]

@jteccampbell,

What error message do you get when you create visualizations and make relationships in Power BI?

You can upload the Excel file to OneDrive, and post shared link of the file here.

Regards,

[jteccampbell]

Unfortunately, no, I am blocked from uploading to OneDrive on my work network.  

I get the following errors:

Trying to creat relationships in BI:

You can't create a relationship between these two columns becasue one of the columns must have unique values.

Import from Access where relationships have been established:

DataFormat.Error: The database had been placed in a state by iser Admin" on machine that preventis it from loading.

--**for this error I simply renamed the database and it loaded...however, ther relationships I created in Access did not come across.

[v-yuezhe-msft · Accepted solution]

---

@jteccampbell wrote:

Unfortunately, no, I am blocked from uploading to OneDrive on my work network.  

I get the following errors:

Trying to creat relationships in BI:

You can't create a relationship between these two columns becasue one of the columns must have unique values.

---

@jteccampbell,

Please follow the guide in this similar thread to create relationship between your tables.

Regards,
Lydia

[dtartaglia]

Hi,

Can you post to an FTP site? One work-around in Excel I've used is to create a new table using the UNION command. This assumes all the Excel tables have exacly the same columns (or at least using the same columns in BI). You may need to create a new column identifying the sheets.

[jteccampbell]

Unfortunately no, we are blocked from FTP sites on my work network.

I don't think the union command will work becasue to sums up items. I need to compair (for example) the number of bananas from tab 1 of my workbook to the actual numbers of bananas being reporting inthe other systems....not add them up. I need to be able to graphically represent that 'this is the amount of bananans we shoud have, this is the amount source 1 is reporting, and this is the varience".

Thanks for your reply