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
Hello
I think your table identifier is wrong.
Try this syntax
=if('Emergency Orders'[request_source], "Requested", "Not Requested")
Hope it helps
Jimmy
I think your table identifier is wrong.
Try this syntax
=if('Emergency Orders'[request_source], "Requested", "Not Requested")
Hope it helps
Jimmy