Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filter 2 Columns In A Table Into A Single Column With True/False

Greetings All -    I've recently inherited a PowerBI desktop report where I need to make some changes. From a high level, I need to compare two columns in a single table and return a value of 'True...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , in DAX

if(not(isblank([EMPLOYEE_ID])) && Not(isblank( [E_PRIMARY_EMPLOYEE_ID] )) && [EMPLOYEE_ID] =[E_PRIMARY_EMPLOYEE_ID]  , true(), false() )

 

in power query

 

if [EMPLOYEE_ID] <> null  and [E_PRIMARY_EMPLOYEE_ID] <> null  and  [EMPLOYEE_ID] =[E_PRIMARY_EMPLOYEE_ID]  then true else  false