Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
If Training Compliance Employee ID matches Active Positions Employee ID then I need it to return Non-Compliant in my new Compliance column.
Hope that makes sense. Any help will be appreciated.
Solved! Go to Solution.
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.
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 WIR |
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 |
Mechanical Equipment | Not Submitted | NS |
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.
That works! Thank you!
Hello @datavis
You can do this using the Edit queries or DAX, but you need to do a workaround, unfortunately you can't do it directly.
I hope this will help you.
Good luck.
Thank you HarrisonCbe,
I used lookupvalue to get compliant or non-compliant.
Training Compliance =
IF (
LOOKUPVALUE ('HHS-DSHS-ActivePositions'[EmplID],'HHS-DSHS-ActivePositions'[EmplID],'DelinquentTraining'[Emplid])
,
"Non-Compliant",
"Compliant"
)
If any names in 'HHS-DSHS-ActivePositions'[Name] is vacant, then 'Delinquent Training'[Training Compliance} column will show Compliant.
Not sure how to write that. Help appreciated.
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |