Emma has attended:
Excel PowerPivot course
Power Pivot
Hi,
I am trying to do a calculation between two tables in the same Power Pivot, they are not directly related (two different periods) but are indirectly linked byt using the same lookup tables.
Any suggestions on trouble shooting as the formulas do not currently work? Only thin I can think is that there are issues becuase they are no directly linked?
Thanks
RE: 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
RE: Power Pivot
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
