Forum Discussion
How to replace NULL with Missing Valu
Hi All
i Need to fill those NULL BRAND with Missing Value. I try below script , it does not work :-
The syntax for ''TABLE'' is incorrect. (DAX(if ( isblank( 'Incidents' 'TABLE'[BRAND]), "Unspecifed" , 'Incidents' 'TABLE'[BRAND]))).
Anonymous
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 🙂
4 Replies
Anonymous
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 🙂
Anonymous
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 🙂