Forum Discussion
Cannot Convert Type Null to Logical
I'm about ready to throw my whole laptop out of the window, so any help would be really appreciated. I'm currently re-doing a dashboard we currently have to optimize the refresh and data load. I...
smather .
this should be like
= Table.AddColumn(#"Changed Type6", "Date 2", each if [PO Recieved]= null then [estimatedclosedate] else [PO Recieved])
Also, check for a boolean column. If you have empty/null value there, it might be giving an error there
Hi amitchandak I changed it back to = null, but the error still occurred 😕 I did have a couple of cols that are true/false that had null values, so I replaced the null with false, and still no joy. Any other ideas?
