how to use if function with empty in power bi

[Anonymous]

Hello All

please I need to write if it is Blank , keep it Blank in the below 

Date of Plan & Actual =

    IF('RS-Procurement'[Actual FAT Date] > 'RS-Procurement'[Planned FAT Date]," Late ",

    IF('RS-Procurement'[Planned FAT Date] >= 'RS-Procurement'[Actual FAT Date]," On Time "

))

thanks

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please try something like below.

Date of Plan & Actual =
SWITCH (
    TRUE (),
    NOT ISBLANK ( 'RS-Procurement'[Actual FAT Date] )
        && NOT ISBLANK ( 'RS-Procurement'[Planned FAT Date] ),
        IF (
            'RS-Procurement'[Actual FAT Date] > 'RS-Procurement'[Planned FAT Date],
            " Late ",
            IF (
                'RS-Procurement'[Planned FAT Date] >= 'RS-Procurement'[Actual FAT Date],
                " On Time "
            )
        )
)

[Anonymous]

Thanks well done