Forum Discussion

zsechler's avatar
zsechler
Frequent Visitor
6 years ago
Solved

IF Statement Help - EoF Error

Hello All   I have a dataset i am trying to simplfy. I have 3 values in one column that i am trying to create a custom column with an "IF" statement to just say billabe or non-billable. I keep gett...
Need Help
fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
6 years ago

 

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"

 

 

fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
6 years ago

P.S. the 'if' 'then' and 'else' have to be lower case!