Multiple Data Tables

[Froggey]

Hi,

Is it possible to use three data tables in Power Pivot?

I have all three data tables connected via look up tables but a calculation I have created doesn't seem to pick up all tables.

Table 1. Sales
Table 2. Sales Adjustment
Table 3. Budget

One of the calculations references Sales and Sales Adjustment but it is only giving me the figure from Sales. Before I added the budget table this worked OK.

Please help it's driving me mad.

 

[akice]

It absolutely can use multiple data tables. But without at least seeing model design and measure code it is not possible to help much.