Forum Discussion
Helper IReplace blank values with "Null" keyword using measure
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).
Helper IWhen I use the ISBLANK() function and trying to select a column in the ISBLANK function, it's throwing error.
Solution SageThis is strange, can you share what is the error?
- anandmitta
It's asking for aggregate value to use in the ISBLANK() function
- ALLUREAN
If you use a measure in your table you can use it:
Measure = IF(ISBLANK([MeasureinTable]), "Null", [MeasureinTable])
- AlexisOlson
Super User
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).