Null Value in Table

[Anonymous]

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.

[amitchandak]

Can you share the column values and error

[Anonymous · Accepted solution]

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