How to replace NULL with Missing Valu

[Paulyeo11]

Hi All

i Need to fill those NULL BRAND with Missing Value. I try below script  , it does not work :-

BRAND_8 = if ( isblank( 'Incidents' 'TABLE'[BRAND]), "Unspecifed" , 'Incidents' 'TABLE'[BRAND])

The syntax for ''TABLE'' is incorrect. (DAX(if ( isblank( 'Incidents' 'TABLE'[BRAND]), "Unspecifed" , 'Incidents' 'TABLE'[BRAND]))).

[Fowmy]

@Paulyeo11 

what is your table name? 'Incidents' 'TABLE'[BRAND] is incorrect.

Do you need to add a new column where if the brand name is blank and insert"Missing Value?

Try like:
New Column  = IF ( 'Incidents' [BRAND] = Blank(), "Missing Value", 'Incidents' [BRAND])

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Paulyeo11]

Hi Sir

I still get error :-

[Fowmy · Accepted solution]

@Paulyeo11 

So your table name is TABLE,
Try:

New Column  = IF ( 'TABLE' [BRAND] = Blank(), "Missing Value", 'TABLE' [BRAND])

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Paulyeo11]

Thannk you sir , it work fine now.