Forum Discussion

alt325's avatar
alt325
New Member
9 years ago
Solved

Create calculated column based off values of two different columns

Hi Everyone,

 

I have some data that looks like the image below (the first two columns), and I am trying to create the rightmost column highlighed in green so that I can graph it out:

 

I've tried: 

NEW COLUMN = if(values(Table[Y/N?] = "N", "N", values(Table[If Y, Type?]))

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

5 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    9 years ago

    try this

    NEW COLUMN = if(Table[Y/N?] = "N", "N", Table[If Y, Type?])

     

    • alt325's avatar
      alt325
      New Member
      9 years ago

      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.

       

       

       

       

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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.