Forum Discussion

mejiaks's avatar
mejiaks
Frequent Visitor
7 years ago
Solved

joining tables

Hi guys   I have two tables   Kms and Incidents   in both tables i have the fileds Country, Division, Month, Year   The only difference is the last field Kms.[Total Kms] Incidents.[Total I...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi mejiaks,

     

    You could create a calculated table with below DAX formula:

    Join Table =
ADDCOLUMNS (
    Kms,
    "Total Incidents", LOOKUPVALUE (
        Incidents[Total Kms],
        Incidents[Country], Kms[Country],
        Incidents[Division], Kms[Division],
        Incidents[Month], Kms[Month],
        Incidents[Year], Kms[Year]
    )
)

     

    Best regards,

    Yuliana Gu

affan's avatar
affan
Icon for Solution Sage rankSolution Sage
7 years ago

Hi mejiaks,

 

As you have shown the tables in your post, there is no unique Key field based on which we can join the tables. This means that we need to provide a field on which PBI can identify that which value from Incidents value should be matched with which row in the Kms table.

 

To resolve this we need to create this field. I have made the below video which will help you to resolve this issue.

 

                                                   

  

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan