Forum Discussion
Issue with conditional column null values since update?
I have a conditional column that I swear was working prior to the June update, but since is giving the error "Expression.Error: We cannot convert the value null to type Logical." for the null values. I have a rule in the column to handle the null values, but it appears to no longer be working? Does anyone know how to fix this or am I missing something really simple?
- Anonymous7 years ago
did your "Time to Close" change data types? I'd start there and see if changing that could help
- Anonymous7 years ago
And actually I think this is related to this issue: https://community.powerbi.com/t5/Issues/June-2019-Update-Cannot-Filter-Null-Dates/idi-p/710872
Changing the data type for the column to the same type that it already is also fixes it.
3 Replies
- AnonymousNot applicable
did your "Time to Close" change data types? I'd start there and see if changing that could help
- AnonymousNot applicable
I don't think so, but on a whim I tried changing the type from "whole number" to "decimal number" and that seems to have fixed it. Thanks for the tip!
- AnonymousNot applicable
And actually I think this is related to this issue: https://community.powerbi.com/t5/Issues/June-2019-Update-Cannot-Filter-Null-Dates/idi-p/710872
Changing the data type for the column to the same type that it already is also fixes it.