Forum Discussion
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.
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])
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])I never knew about find and replace! Worked a treat, thanks :)