Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF Statement with blanks

I have a column that has blanks in that I want to say 'Other' when there is a blank. Is an IF statement the best way to do this? I don't want another column with the data in, only this one.

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Probably best to do this in Power Query, Just use find and replace. or in DAX you can try a calculated column

    Column = if( LEN('Table'[Column1])=0,"Other",'Table'[Column1])

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Probably best to do this in Power Query, Just use find and replace. or in DAX you can try a calculated column

    Column = if( LEN('Table'[Column1])=0,"Other",'Table'[Column1])
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I never knew about find and replace! Worked a treat, thanks :)