Calculation Group Help!

Hi:

I understand it more now. I beleive you will want to have your currency index as your slicer that has a one to many relationship with both your invoice and budget tables.

The other modeling idea is to structure your info a bit differently.  Both the Budget and Invoice tables can be unpivoted and include your currency index/ID key.

Roughly:

Currency ACT USD Index 1

               ACT GBP Index 2   etc  This is the lookup table or slicer which connects to the other fact tables.

The Fact tables would be more like:

Proj ID   xxxV12   Date  Amount  Curr_ID

They now will be much longer and not as wide. Both of these fact tables conect to your slicer table on the Curr_ID which will solve your problem.

I'm more used to seeing a currency conversions applied against one amount and mostly calculating out each countries amonts vs. having all the figures complete like you have. Either way you'll want a slicer table for currencies, joined on an index key in a one to many relationship with both of your fact tables. Those fact tables will have currency ID that join to the currency slicer table.

I hope this make sense! Thanks