Conditional Column

[Anonymous]

Hi,

I have table and would like to create a column with below logic. I am using directquery so unable to use add column function under the transform data. 

If status="not ready" then use reason code from ReasonCode column else use the Status. 

Agent	Status	ReasonCode	***New column needed
1	Ready		Ready
2	Not Ready	Break	Break
3	Not Ready	Meeting	Meeting

Thanks,

Daven 

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Try this

Column = IF( CONTAINSSTRING('Table'[Status], "Not Ready"), 'Table'[ReasonCode], 'Table'[Status])

Regards

Phil

[Anonymous]

Thanks Phil!