Forum Discussion

NISH72's avatar
NISH72
Icon for Helper IV rankHelper IV
6 years ago
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 ...
Need Help
Show and Tell
Tips and Tricks
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    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] ) )

     

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

Hi NISH72 ,
Try this. Use = BLANK()

 
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

NISH72's avatar
NISH72
Icon for Helper IV rankHelper IV
6 years ago
It's throwing same error
    • NISH72's avatar
      NISH72
      Icon for Helper IV rankHelper IV
      6 years ago
      Error -expressions that yield variant data types cannot be used to define calculated columns
      • jdbuchanan71's avatar
        jdbuchanan71
        Icon for Super User rankSuper User
        6 years ago

        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] ) )