Forum Discussion

powerbidev123's avatar
powerbidev123
Icon for Solution Sage rankSolution 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,

     

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper 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,