New column with if condition

Hi All,

I am new to Power BI and would appreciate your help

I have a table in SQL which I import using Direct query in power BI. I need to create a new column with some simple data manipulations, such as IF(col1 = value && col2 = value && col 3=value, 1, 2)

I expect a new column return 1 or 2 values in each row 1 where condition is true and 2 when condition is not true.

Basically this can be any other values just to distinguish when condition is met and when is not for filtering and count

However it returns a column with random numbers.

Please help!

thnx