Forum Discussion

Kallagan's avatar
Kallagan
Frequent Visitor
8 years ago
Solved

match 2 columns from 2 different tables

Hello I'm new to Power BI and to the BI world in general.   I have to match 2 columns from 2 diffrent tables. One table contains the name of people in an organization and the other table contain t...
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

     

    can you please upload your pbix to onedrive or dropbox and then post the link.

     

    Here is a scrrenshot from my testdata

    I'm using this DAX statement to create the Calculated Column: HasAttended

    HasAttended = 
IF(
    ISBLANK(
        LOOKUPVALUE(trainings[Name],trainings[Name],'employees'[Name])
    )
    ,"No"
    ,"Yes"
)

     

    Regards

    Tom

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Kallagan,

 

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

 

Best Regards!
Dale