Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
char23
Helper II
Helper II

Null 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 write, if [Column1] <> null and [Column2] <> null then "write text" or a statement like if [Column1] = null then "write text", but I keep getting errors. I can't change the null values to a bogus date like (1/1/1900) because it will affect the values I calculate for this column. 

3 REPLIES 3
Anonymous
Not applicable

Hi @char23 ,

Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

In addition, you can also take a look at the following link about handle with blank in dax.

How to handle BLANK in DAX measures - SQLBI

Regards,

Xiaoxin Sheng

lbendlin
Super User
Super User

definitely 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.

Hello, 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]"

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors