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