Forum Discussion
Solved
How can I use an OR function inside an IF statement in PowerQuery?
I am using Power BI Desktop, and I have imported a table from a SQL Database. I am under 'Data | Edit Query | Add Column | Custom Colunn', and having problems getting my formula to work. I would li...
Hi nick-evans,
Try this formula please.
=if [NAME] = "Nick" or [NAME] = "Sally" then "true" else "false"
Reference: https://msdn.microsoft.com/en-us/library/mt186365.aspx
Best Regards!
Dale
Hi nick-evans,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
Hi v-jiascu-msft it works I just tried it.