Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Null Value in Table

I have a set of date fields in a column. The data type is kept as date only in Power BI. 

When the cells are blank then i need to display NULL. However when i am trying to createa  calculated column, it is not support since NULL can't exists in date datatype.

 

At the same time i cant change the date datatype to text since i need to maintain the format DD-MMM-YY.

 

Please help.

  • Anonymous's avatar
    Anonymous
    6 years ago

    You can change it to text using FORMAT() in DAX. This way it will save it as text in DD-MMM-YY

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    You can change it to text using FORMAT() in DAX. This way it will save it as text in DD-MMM-YY