Forum Discussion

Swapnab's avatar
Swapnab
New Member
4 years ago
Solved

Replace blanks.nulls in column with another value

Hi I have a below scenario where the New Calculated column need to be derived from Category column .For Category(N/A,Null or blank) value should be Adj's and others would remain same.Can Someone please help how to write this in DAX.

 

Types(Table Name)

CategoryNew Calculated  column
INTINT
NATNAT
N/AAdj's
INLINL
MCMC
US_EUS_E
OTHEROTHER
HCHC
Null or Blank Adj's

 

Thanks..

Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Does this work?

    IF ( Types[Category] IN { "N/A", "", BLANK() }, "Adj's", Types[Category] )

2 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    Does this work?

    IF ( Types[Category] IN { "N/A", "", BLANK() }, "Adj's", Types[Category] )