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

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
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

Kallagan's avatar
Kallagan
Frequent Visitor
8 years ago

Sorry for my late answer.

 

Thank you very much for your help.

 

 

Again sorry for my late answer.

 

 

Regards