Expression error when filtering on Conditional Column

Jimmerding
Posts: 1
Joined: Thu Jun 27, 2019 12:39 am

Expression error when filtering on Conditional Column

Postby Jimmerding » Thu Jun 27, 2019 12:51 am

Hi all,

Complete novice here. Trying to create a simple conditional column, then filter on it.

Logic is:

If
Column A contains "Cancelled During Trial period",
then "LOST",
else *Column B*

Then filter the whole query on Col B value "LOST".

I can get everything to work fine up until I filter the column on LOST, at which point I get the error "Expression Error: we cannot convert the type Null to type logical" even though there aren't any null values...

Any help would be greatly appreciated! is it not possible to filter the data on a conditional column you create within the query?

PhilC
Posts: 274
Joined: Tue Sep 09, 2014 8:13 am

Re: Expression error when filtering on Conditional Column

Postby PhilC » Thu Jun 27, 2019 8:15 am



Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 0 guests