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
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