Need help with formatting

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,