New column with if condition

[tananich]

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

[Anonymous]

@tananich I don't see why your IF statement would be returning random numbers. Can you send a screenshot that includes the formula and the table?

[tananich]

@Anonymous

see below

[Anonymous · Accepted solution]

Right, so the visualization is summing the column.

Click on the visualization > In the visualizations panel on the right, click the down-arrow highlighted in the picture below > select "Don't summarize"

[tananich]

@Anonymous right, thnx a lot, dunno how i haven't noticed