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"...
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

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