Forum Discussion

mikeng's avatar
mikeng
Frequent Visitor
8 years ago
Solved

calculation using 2 fact tables

Hi guys, I'm struggling for days on this problem. So I have 2 fact tables (assume that they are linked by all necessary Dimension tables): Table A: which contains value (USD) Table B: allocation ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

mikeng's avatar
mikeng
Frequent Visitor
8 years ago

Thanks so much for simulating a PBI for it. But if it works correctly, the total amount of "Allocation" must be 72,097.00.

By the way, please note I've just edited the Table B rate (it was wrong the first time, so sorry!).

Mike