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)
     
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!