Forum Discussion

jppuam's avatar
jppuam
Icon for Helper V rankHelper V
4 years ago
Solved

bring field from 3rd table

Hello, i need to create a calculatedtable with data that is from 3 tables, like the picture below. i have 2 tables connected through the dates table, and other (tax) connected to payments table.  ...
Need Help
  • moizsherwani's avatar
    moizsherwani
    4 years ago

    I have used a similar structure to the one you have given. Can you see if the calculate table sample I provided in my earlier message helps? 

     

     

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Create a dimension table with unique values for Obj_ID, delete the relationship between payments and tax tables, and create a one-to-many relationship between the Dim OBj and the three fact tables.