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

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 years ago

Hey,

 

I would not merge both tables (means, after the merge there is just one table). Instead I would create a calculated column in the employees table like so

Has attended a training = 
IF(
	ISBLANK(
		LOOKUPVALUE(Training[Column1],Training[Column1],'employee'[Column1])
	)
	,"NO"
	,"YES"
)

Hopefully this what you are looking for.

 

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
        9 years ago

        Sorry for my late answer.

         

        Thank you very much for your help.

         

         

        Again sorry for my late answer.

         

         

        Regards