Forum Discussion

Kallagan's avatar
Kallagan
Frequent Visitor
9 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
    9 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
9 years ago

Hello Tom

 

First of all thank you for your answer that is exactly what I was looking for. Sadly, the request only returns 4 results ("True in the calculated column) where I should have 91 "True".

 

 

The employees that has returned true don't have anything special. Am I doing something wrong ?

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