Forum Discussion

Steffen1's avatar
Steffen1
Frequent Visitor
3 years ago

Null Values in Date Column

Dear Community,    I´ve already seen some post on this topic, but it kinda not solved my problem.    I have a report that shows me the ship date for an order. However, if the order hasn´t shipped...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Steffen1 - it looks like you need to change something in Power Query to allow the Dax to work.  If you see the following images, the left contains (blank).  This is the desired result in data model.  Contrast this with the right, which is populated with text string "(Null)"

This is how the (Blank) and "(Null)" text string appears in Power Query.  We need the result on the left.

I would suggest using "Replace Values" to turn the string (Null) to null.  keep the null in lowercase so Power Query recognises this as null instead of "Null" or "NULL".

 

Also make sure that Data Type for the column is Date.

 

Many thanks

Daryl

 

Steffen1's avatar
Steffen1
Frequent Visitor
3 years ago

Hi Anonymous,

 

in my data view it shows me as you said, the blank, which is the desired result but I wonder if there is a solution within the Power Query to deal with the null values via M-Language and not DAX?

 

 

Thank you very much for the support

Steffen