Power Pivot

Hi Emma

Thanks for your question.

Unfortunately, due to the content of your question the relevant trainer won't be free to answer until next Tuesday. They will get back to you as soon as they can.

Sorry for the inconvenience.

Regards,

Sarah
Excel Trainer

Hi Emma,

Thank you for the forum question.

It is not a problem that the tables are not directly related. You can use the Related function or the Calculate function or the Lookupvalue function to calculate tables, which are not directly related.

If you try to calculate between two fact tables (many to many related tables), it can be a complicated task.

Lets say that you have a table with department expenses and another table with department income and you have the different departments many times on each table. If this is the case you may need to create a bridge table between the two tables with the department name as the unique value on the bridge table. If you relate the bridge to the two table (the department name on the bridge table is the primary key, the department name on the expenses table is the foreign key and the department name on the income table is the foreign key).

This will make it possible to break down the expenses and income by department.

I hope this makes sense.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector