Forum Discussion

powerbidev123's avatar
powerbidev123
Solution Sage
1 year ago
Solved

Need help with formatting

How can i fix this error.

 

TIA

DAX
Need Help
  • DataNinja777's avatar
    DataNinja777
    1 year ago

    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,

     

2 Replies

  • DataNinja777's avatar
    DataNinja777
    Super User
    1 year ago

    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,