IF Statement Help - EoF Error

Power Query 'Custom Columns' are different than DAX 'New Column'.  Try this...

= if [#"Task - Phase/Task name"] = "Fixed Fee (Billable)" or [#"Task - Phase/Task name"] = "T&M (Billable)" or [#"Task - Phase/Task name"] = "Milestone (Billable)" then "Billable" else "Non-Billable"

Hi zsechler ,

As fhill's suggestion, the formula in Power Query will works well. If the result returns the false value of non-billable, it means that the IF condition don't meet the actual values. Please pay attention to the case sensitive(lower case) and the accurate value within the "" in IF function, check if there may be spaces in "".

You can refer to the link:https://www.myonlinetraininghub.com/power-query-if-statements.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.