Need help with formatting

[powerbidev123]

How can i fix this error.

TIA

[DataNinja777 · Accepted solution]

Hi @powerbidev123 ,

Please try the following instead.

Login Status = IF(Query1[LastLogIn] = BLANK(), "Yet to Login", FORMAT(Query1[LastLogIn], "YYYY-MM-DD"))

This ensures that both return values are Text, avoiding type mismatch errors.

Best regards,

[powerbidev123 · Accepted solution]

Thanks @DataNinja777 

[DataNinja777 · Accepted solution]

Hi @powerbidev123 ,

Please try the following instead.

Login Status = IF(Query1[LastLogIn] = BLANK(), "Yet to Login", FORMAT(Query1[LastLogIn], "YYYY-MM-DD"))

This ensures that both return values are Text, avoiding type mismatch errors.

Best regards,