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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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