Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Token RightParen Error With IF Function

I think DAX is having a meltdown here. I originally had a column named "request_source" that is a 1 or 0 field. I converted this to True/False. I want to create another column that states "Requested" if true, or a "Not Requested" if false. The DAX function I'm using is as follows:

=if(#"Emergency Orders"[request_source], "Requested", "Not Requested")

The intellisense is putting a red squiggly under the q in "Requested" and saying "Token RightParen expected." This makes no sense, and I have no idea what I'm doing wrong. Any help would be appreciated.

 

 

Need Help
  • Jimmy801's avatar
    Jimmy801
    6 years ago

    Hello Anonymous 

     

    DAX is the language to be used in your data model. Your original function posted is a mixture of DAX and Power Query.

    Power Query is the mashup language used in Power BI to reshape your data.

    However - this is the function in DAX

    =if('Emergency Orders'[request_source], "Requested", "Not Requested")

    this is the power query version

    =if #"Emergency Orders"[request_source] then  "Requested" else "Not Requested"

     

    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy

4 Replies

  • artemus's avatar
    artemus
    Microsoft Employee
    6 years ago

    There might be a character encoding issue. Try to replace the quote marks with ones from your keyboard.

     

    Also, sometimes the incorrect indicator (red squiggly) is off while changing the formula. See if it is still there when you click off and back onto the calculated column.

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    6 years ago
    Hello

    I think your table identifier is wrong.
    Try this syntax
    =if('Emergency Orders'[request_source], "Requested", "Not Requested")

    Hope it helps

    Jimmy
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for your all's help. I ended up creating the column outside of PowerQuery and it worked fine? That was odd. Apparently the syntax for PowerQuery and creating a column directly from the report is different.

    • Jimmy801's avatar
      Jimmy801
      Community Champion
      6 years ago

      Hello Anonymous 

       

      DAX is the language to be used in your data model. Your original function posted is a mixture of DAX and Power Query.

      Power Query is the mashup language used in Power BI to reshape your data.

      However - this is the function in DAX

      =if('Emergency Orders'[request_source], "Requested", "Not Requested")

      this is the power query version

      =if #"Emergency Orders"[request_source] then  "Requested" else "Not Requested"

       

      If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
      Kudoes are nice too

      Have fun

      Jimmy