Forum Discussion
char23
Helper II
Helper IINull dates fields with custom column
How can I deal with null values in a date column in power query. I am basically trying to deal with blank values that show null in power query, but show as blank in the dashboard view. I am trying to...
lbendlin
Super User
Super Userdefinitely avoid using bogus dates. Consider using COALESCE([date],TODAY()) or consider ignoring these values in your measure. If you provide some more details it will be easier to assist.
char23Helper II
Helper IIHello, thank you for the response. I am trying to write nested if statements in power query for a conditional column. I keep getting the error
"Expression.Error: We cannot convert the value null to type Logical.
Details:
Value=
Type=[Type]"