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?
Ok, so this is all in Power Query preview screen?
What is the Grouping M code?
Do you have null values in your data?
I've just realised I had null value in one column. There was so much data that it hadn't all loaded so I didn't see it intially, but once I've selected 'load more' it's become visible.
Thank you for your help!
