Forum Discussion
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. ...
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
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
That works! Thank you!
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.
I want to compare two columns in two different tables by text. After that I want to count them.
- g Equipment Table Having Status Column with value “Not Submitted” & Same Values with Same Column Name in MASTER LIST Table. So I want total “Not Submiited” from Both table. Attached alos is PBX file
O&M Not Submitted O&M Not Submitted O&M Not Submitted O&M Not Submitted O&M Not Submitted O&M Not Submitted O&M Not Submitted O&M Not Submitted O&M Not Submitted O&M Not Submitted O&M Not Submitted DELIVERABLES Status TESTING
WIRMechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS Mechanical Equipment Not Submitted NS