Error in PowerQuery We cannot convert a value of type Record to type Logical

[FOliveira]

Hello everyone,

I have this error when trying to add a Custom Column

The new column shows error and the error is:

Any help would be much appreciated

[FOliveira]

I apologize, but I forgot to add the Query:

= Table.AddColumn(#"Filtered Rows", "Custom", each if [#"Type(3)"] = "user" and [#"Internal/External(4)"] = "internal" and [#"Position(5)"] = "office" and [#"BYOD(8)" = "corp"] then "HybridWorkers" else "Empty")

[SundarRaj · Accepted solution]

Hi @FOliveira 

I think this might be the error - [#"BYOD(8)" = "corp"], that basically means your Record name is #"BYOD(8)" = "corp" but it is "BYOD(8), so -->
Should be just [#"BYOD(8)"]  = "corp"
Thanks.

[FOliveira]

Sorry again, the ] was out of place...