Forum Discussion

kelly008's avatar
kelly008
Helper I
4 years ago
Solved

Replacing (BLANK) field with Text

Hello,   I am currently trying to replace a (blank) field with the text "Machine Check not Carried Out". The column itself is also in text format.   However, I can't seem to find the correct meas...
Need Help
  • vojtechsima's avatar
    vojtechsima
    4 years ago

    Hi, kelly008 
    Try this

    MKMachineBlank = 
var CurrentItem = SELECTEDVALUE('Preventative Maintenance Log'[MaintenanceRequired2])
return IF( ISBLANK(CurrentItem )||CurrentItem = "", "Machine Check Not Carried Out",  CurrentItem)
     
kelly008's avatar
kelly008
Helper I
4 years ago

Hi, thanks for replying, sorry I may not have included all of the relavent information. 

 

I'm currently getting this error after using the measure you suggested:

 

 

I'm guessing this is becuase I didnt include the table that the column is coming from? This is the table alongside the column and the measure you suggested:

Again, thank you for replying.

vojtechsima's avatar
vojtechsima
Super User
4 years ago

Hi, kelly008 
Try this

MKMachineBlank = 
var CurrentItem = SELECTEDVALUE('Preventative Maintenance Log'[MaintenanceRequired2])
return IF( ISBLANK(CurrentItem )||CurrentItem = "", "Machine Check Not Carried Out",  CurrentItem)
 
  • kelly008's avatar
    kelly008
    Helper I
    4 years ago

    Thats it! Thank you!