Forum Discussion
Create calculated column based off values of two different columns
If you're getting that error message, it means you're creating a measure not a column. Either that or you're referencing a column from a different table. from the one where you're entering the new column.
Hi,
Thanks for the quick reply. Unfortunately, it does not let me do that. After the IF(, I can only enter other calculated measures and do not have the option of entering the Table[ColumnName], and when I do it manually, I get an error that says:
A single value for column 'Y/N?' in table 'Table' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
If you're getting that error message, it means you're creating a measure not a column. Either that or you're referencing a column from a different table. from the one where you're entering the new column.
Turns out I was creating a Calculated Column in a different table than where I wanted to put the column - Thanks so much!