Forum Discussion
Anonymous
6 years agoNot applicable
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.
- Anonymous6 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
- AnonymousNot applicable
You can change it to text using FORMAT() in DAX. This way it will save it as text in DD-MMM-YY
- amitchandakSuper User
Can you share the column values and error