Forum Discussion

Steffen1's avatar
Steffen1
Frequent Visitor
4 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
Steffen1's avatar
Steffen1
Frequent Visitor
4 years ago

Hi Anonymous 

 

thank you very much for your quick reply and the tip to check if its really containing null.

 

Im not an expert but for me it looks like it does contain null? 

 

 

Dax could be an option but my preference would be within the power query/M, if possible?

 

Thanks 

Steffen

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 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
      4 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