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? 

     

     

moizsherwani's avatar
moizsherwani
Icon for Continued Contributor rankContinued Contributor
4 years ago

I agree with the users that the schema seems to be incorrect. But for what it's worth the following will get you the result (Note: it may not be the most efficient method since more details about the tables are required)

 

CalTable =
ADDCOLUMNS (
    Invoices,
    "TAX_A", LOOKUPVALUE ( Tax[TaxA], Tax[ObjID], Invoices[ObjID] ),
    "TAX_B", LOOKUPVALUE ( Tax[TaxB], Tax[ObjID], Invoices[ObjID] )
)