Forum Discussion

ruanctorres's avatar
ruanctorres
Frequent Visitor
9 years ago
Solved

Joining tables without primary key

Hi everybody,   Im trying to join tables with no primary keys. Is it possible?   For example:   Table 1:   Table 2:     A need a table result where for each day I have all the ...
Need Help
  • ruanctorres's avatar
    ruanctorres
    9 years ago

    Hi Lydia,

     

    Thanks for your time. In fact, I solved this problem creating a column in both tables, filling the rows with the same result, for example "1".

     

    Best regards.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

ruanctorres,

Are there matching rows between the two tables? If not, it will return null result when you use "Merge Queries", please create new table using the DAX below and check if you get expected result. If you have matching rows between two tables, expand the new column after you use "Merge Queries", you can review this blog to get more details.

Table  = CROSSJOIN(Table1,Table2)


Regards,
Lydia

  • ruanctorres's avatar
    ruanctorres
    Frequent Visitor
    9 years ago

    Hi Lydia,

     

    Thanks for your time. In fact, I solved this problem creating a column in both tables, filling the rows with the same result, for example "1".

     

    Best regards.