Change two separate values out of a column with DAX messure

[Valnus]

Hi 

So I have a colum that has two value types  ( blank and numbers ). The numbers are unique. 

I need to change the Blank entries to text and I need to change all the numbers to text aswell. 

So blank needs to be replaced with "Blue". And 1 to 5 needs to be changed to "Red"

I have managed to change blank to "Blue" very poorly. I first counted all the blanks in a messure then via another messures replaced Blank. The number change is evading me. 

Any suggestions ? 

[Tahreem24 · Accepted solution]

@Valnus Create a column like below:

Result Column = IF(TableName[ValueColumn]=BLANK(),"Blue","Red")

Then take table and add yourValue Column and above newly created column and mark this new column as "show titem with no data" just like below screenshot.

[johnt75]

Use Power Query. Make sure that the column type is numeric and add a conditional column that gives Red if the value is between 1 and 5, Blue if the value is null and gives the existing value otherwise. Once you have added the conditional column you can delete the base column if you don't use it for anything else.

[Valnus]

Hi 

So the colum is numeric as there are alot of numbers ( ID's ) & the null values in the column 
So I need to change all the null's to "Main Member" & all the random 1 to 5 digits to " Dependent" 

[johnt75]

That's even simpler then, just add a conditional column which gives "Main Member" if the value in your column is null otherwise it gives "Dependent"

[Valnus]

So an IF statment ? 

I tried but when I wanted to get a COUNT of each to use with another value. 

Can you give me an example of the DAX statment please