Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Matching Data in two tables

In Power BI desktop I have two sets of data, both of which have a column called Employee ID. I need to create a column called Compliance using the Employee IDs that match between the two data sets. ...
  • v-lili6-msft's avatar
    v-lili6-msft
    8 years ago

    Hi@ datavis

    You can use ISBLANK() function like below:

    Column = IF(ISBLANK(LOOKUPVALUE(Table7[EmplID],Table7[EmplID],Table6[EmplID])) ,  "Compliant",
    "Non-Compliant"
)

     

    Result:

    Basic data

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
8 years ago

Hi@ datavis

You can use ISBLANK() function like below:

Column = IF(ISBLANK(LOOKUPVALUE(Table7[EmplID],Table7[EmplID],Table6[EmplID])) ,  "Compliant",
    "Non-Compliant"
)

 

Result:

Basic data

 

Best Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Sorry, when I say Vacant, I don't mean Blank. The word Vacant is in the Name column when the position is vacant so ISBLANK won't work.

 

Column = IF(ISBLANK(LOOKUPVALUE(Table7[EmplID],Table7[EmplID],Table6[EmplID])) ,  "Compliant",
    "Non-Compliant"
)

 

So, if EmplID column in the delinquent table matches the the EmplID column in the Active Positions table then Non-Compliant but if Name is Vacant then Vacant.