IF statement to check if values match

[aishak12]

Hi All, 

I want to create a new column to check if (RECOMMENDED_BLK = PR_BLK) if values match return a 1, if they do not match return a 0. Does anyone know if this is possible.

[Anonymous · Accepted solution]

Hi @aishak12 ,

You could also use add conditional column feature in Query Editor.

Best Regards,

Jay

[Fowmy]

@aishak12 

Are these two columns in the same table or different tables? If som in which table do you want to create a new column?

[aishak12]

They are all the same table. I would like to create a new column in that same table 

[Fowmy]

@aishak12 

Add a new column as follows:

Match = IF ( TABLE[RECOMMENDED_BLK] = TABLE[PR_BLK] , 1 , 0 )

 

[aishak12]

Hi I am receiving error do you know why 

[Ashish_Mathur]

Hi,

Fowmy's suggestion is to write the calculated column formula in DAX whereas you are writing the formula in the Query Editor.  If you want to write it in the Query Editor, then try this

=if TABLE[RECOMMENDED_BLK] = TABLE[PR_BLK] then 1 else 0