Measure

[Anonymous]

Hi everyone,

how can I add a new column with a measure when I need a column that is not recognized without using the query editor? I tried using an IF function, however the column cannot be recognized.

example:

yes/no_number	yes/no
0	no
1	yes
0	no
0	no
1	yes

how can I create the "yes/no" column?

Thank you in advance,

[Greg_Deckler · Accepted solution]

@Anonymous You need to use an aggregation when referring to a column in a measure like MAX, SUM, etc.