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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
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

mejiaks's avatar
mejiaks
Frequent Visitor
7 years ago

That is EXACTLY what I needed and EXACTLY what I was looking for

 

simple, straight forward and fast

 

Thanks a lot