Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Token RightParem expected in IF statement

I want the table to be like this but i am currently stuck at token rightparem error. 

 

So i am currently creating a new column where if the rating value is true, it will show what the rating type is and null if it is false. 

However, I dont know where the issue is. From what I understand, the error occurs when there is missing bracket or etc. I just started learning Power BI so I hope you can help me with this.

Need Help

4 Replies

  • pratyashasamal's avatar
    pratyashasamal
    Memorable Member
    3 years ago

    Hi Anonymous ,
    Please try this 
    Rating = IF( 'Table'[Rating Type] == True,[Rating Type],null )
    OR
    Rating = IF( 'Table'[Rating Type] == True,[Rating Type],"" )
    Please refer to this link to learn more about If function : https://learn.microsoft.com/en-us/dax/if-function-dax
    Thanks ,
    Pratyasha Samal 
    Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
    If you found this post helpful, please give Kudos C

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      So i change the formula to this  

      IF( 'TestTable'[Rating Type] == True,[Rating Type],null )

      as I assume the "table" refers to my table name.

       

      So now i have another error "Token Literal"

      • pratyashasamal's avatar
        pratyashasamal
        Memorable Member
        3 years ago

        Hi Anonymous .
        Please try as well
        Measure =         IF( 'TestTable'[Rating Type] == True,[Rating Type],"" )
        Thanks ,
        Pratyasha Samal 
        Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
        If you found this post helpful, please give Kudos C