https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-formatting/m-p/4361655#M173166 <P>Thanks&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="608865" data-lia-user-login="DataNinja777" class="lia-mention lia-mention-user">DataNinja777</a>&nbsp;</P> Mon, 13 Jan 2025 14:13:54 GMT powerbidev123 2025-01-13T14:13:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-formatting/m-p/4361569#M173157 <P><img /></P><P>How can i fix this error.</P><P>&nbsp;</P><P>TIA</P> Mon, 13 Jan 2025 13:15:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-formatting/m-p/4361569#M173157 powerbidev123 2025-01-13T13:15:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-formatting/m-p/4361579#M173158 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="752610" data-lia-user-login="powerbidev123" class="lia-mention lia-mention-user">powerbidev123</a>&nbsp;,</P> <P>&nbsp;</P> <P>Please try the following instead.</P> <LI-CODE lang="markup">Login Status = IF(Query1[LastLogIn] = BLANK(), "Yet to Login", FORMAT(Query1[LastLogIn], "YYYY-MM-DD")) </LI-CODE> <P>&nbsp;</P> <P>This ensures that both return values are Text, avoiding type mismatch errors.</P> <P>&nbsp;</P> <P>Best regards,</P> <P>&nbsp;</P> Mon, 13 Jan 2025 13:23:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-formatting/m-p/4361579#M173158 DataNinja777 2025-01-13T13:23:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-formatting/m-p/4361655#M173166 <P>Thanks&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="608865" data-lia-user-login="DataNinja777" class="lia-mention lia-mention-user">DataNinja777</a>&nbsp;</P> Mon, 13 Jan 2025 14:13:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-formatting/m-p/4361655#M173166 powerbidev123 2025-01-13T14:13:54Z