Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need to create a table using DAX pulling columns from two different tables

Hi there,

Hope you can help.  I am journeying towards adequacy but need lots of help still.

 

I have 2 tables in this example, I want to pull the results of table 2 (Fee Yield) into Table 1 (Amort Factor), I could do a LOOKUPVALUE by creating a Unique ID but i was really wanting to create one table from the two as i have others that i want to add on.  Any suggestions on how to do this?

Table 1Table 2

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hey Anonymous 

    Anyhow you'll need a PK to identify each record.

    How can you match records without an ID?
    Cheers!
    A

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous ,

    Have you solved the problem?

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please share your data sample which could reproduce the scenario and your desired output so that we could help further on it.

    Best  Regards,

    Cherry