Forum Discussion
Solved
Cannot convert the value null to type Logical
I have a conditional column: if [startdate] >= [validtodate] then 1 else 0 which produces a result. However when I filter on the result column (only to include 1) and then group the result, I'm pre...
Ok, so this is all in Power Query preview screen?
What is the Grouping M code?
Do you have null values in your data?
"when I filter on the result column" - you have created a visual with the column in it? What visual and what else is in it?
"then group the result" - what does this mean? how are you grouping it?
Sorry, no, when I say filter, I mean, once I have the result of the conditional column above then I've filtered that column to only show the '1'.