https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-convert-the-text-to-Time-format/m-p/3064535#M156959 <P>Hi,&nbsp;</P><P>&nbsp;</P><P>i have the below formula for hh:mm:ss but then it is defaulted to be text format. when i try to change the data type to time, it is giving me an error. please see screenshot below:</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>here is the error i am getting:</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>thank you.</P> Mon, 06 Feb 2023 18:44:15 GMT Anonymous 2023-02-06T18:44:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-convert-the-text-to-Time-format/m-p/3064535#M156959 <P>Hi,&nbsp;</P><P>&nbsp;</P><P>i have the below formula for hh:mm:ss but then it is defaulted to be text format. when i try to change the data type to time, it is giving me an error. please see screenshot below:</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>here is the error i am getting:</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>thank you.</P> Mon, 06 Feb 2023 18:44:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-convert-the-text-to-Time-format/m-p/3064535#M156959 Anonymous 2023-02-06T18:44:15Z