Forum Discussion
Solved
Show null values as na
Hi I have a city column with some blank values in it. What will be the dax for new calculated column so that if the value is blank in City column it will show as "n/a" in new calculated column and if ...
You have to convert the output of the non-blank to text as well in order for it to display "N/A" on the blanks.
Column = IF ( ISBLANK ( 'Table'[Sales] ), "N/A", TRIM ( 'Table'[Sales] ) )
You have to convert the output of the non-blank to text as well in order for it to display "N/A" on the blanks.
Column = IF ( ISBLANK ( 'Table'[Sales] ), "N/A", TRIM ( 'Table'[Sales] ) )
How to convert. Can you please share. Thanks