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? 

     

     

daxer-almighty's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
4 years ago

The schema is at least incomplete. We don't know what kind of relationships there are between the tables, what the Date dimension points to in the related tables and why there's no relationship between the Invoice dimension and the Payments fact table. Because of the latter, the schema seems to be incorrect.