Error when adding Conditional Columns - We cannot convert the value null to type Logical.

[m_pat]

I am dealing with a client's contact list excel file from Marketo, and have appended additional contacts to the file in the same format as the client's list - I did this in the original Excel. In query editor I am trying to add conditional columns based on campaign names - "If Campaign Name=X, Campaign Description = Y." The Campaign Name in the new records I appended to the excel file are identical to the ones that were already in the client's file. But in the rows containing my additional contacts, I am getting this error in the new conditional column field: 

Expression.Error: We cannot convert the value null to type Logical.
Details:
Value=
Type=Type

What is causing this error and how can I resolve it? 

[v-juanli-msft]

Hi @m_pat 

How did you add the conditional column?

Please refer to the blog how to add a conditional column.

https://www.sumproduct.com/blog/article/power-query-blogs/power-query-in-terms-of-conditional-column...

If you write code in Advanced editor, please share it and tell me your final needs.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[kcantor]

@m_pat 

Can you share some sample data or the query where the error appears?

Also, try deleting the change type and creating the calculated column prior to assigning types within the query.