Forum Discussion
anandmitta
Helper I
Helper IReplace blank values with "Null" keyword using measure
Hi, I have a table visual with contains many date/time rows and columns. There are many blank values in the table. Is it possible to replace all the blank values in the visual with t...
Note that if the measure here doesn't return text values, then you may get an error about IF returning different data types. You can fix this by wrapping the measure with FORMAT. and specifying the format you'd like (e.g. "General Date" or "yyyy-mm-dd" or "c" etc).
ALLUREAN
Solution Sage
Solution SageHi, anandmitta
Try something like:
Measure = IF(ISBLANK(Table[Date]), "Null", Table[Date])
Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.
Appreciate your Kudos !!!
anandmittaWhen I use the ISBLANK() function and trying to select a column in the ISBLANK function, it's throwing error.
- ALLUREAN
This is strange, can you share what is the error?
- anandmitta
It's asking for aggregate value to use in the ISBLANK() function