topic Re: How to format different time&amp;date zone into EST in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-format-different-time-amp-date-zone-into-EST/m-p/2094219#M47719 <P>Can't we convert TEXT to Date/Time ?</P> Thu, 23 Sep 2021 12:07:16 GMT Manasi25 2021-09-23T12:07:16Z How to format different time&date zone into EST https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-format-different-time-amp-date-zone-into-EST/m-p/2092791#M47667 <P>I have my data below and i need to format each row into EST date &amp;time zone.</P><P>&nbsp;</P><P>Please advise !</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 23 Sep 2021 02:39:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-format-different-time-amp-date-zone-into-EST/m-p/2092791#M47667 Manasi25 2021-09-23T02:39:49Z Re: How to format different time&date zone into EST https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-format-different-time-amp-date-zone-into-EST/m-p/2092851#M47671 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="285158" data-lia-user-login="Manasi25" class="lia-mention lia-mention-user">Manasi25</a>&nbsp;Just add 4 hours. or [TIME} + (4 * 1/24)</P> Thu, 23 Sep 2021 03:12:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-format-different-time-amp-date-zone-into-EST/m-p/2092851#M47671 Greg_Deckler 2021-09-23T03:12:08Z Re: How to format different time&date zone into EST https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-format-different-time-amp-date-zone-into-EST/m-p/2092961#M47674 <P>Hello Greg<BR /><BR />Thank you for response.<BR />I have added hours to this "TIME" col, but due to it's having "text" format , value can not convert.<BR /><BR />I changed format to"DATE/TIME" as well, still getting error.<BR /><BR /></P><P><img /></P><P>&nbsp;</P> Thu, 23 Sep 2021 04:50:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-format-different-time-amp-date-zone-into-EST/m-p/2092961#M47674 Manasi25 2021-09-23T04:50:49Z Re: How to format different time&date zone into EST https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-format-different-time-amp-date-zone-into-EST/m-p/2094219#M47719 <P>Can't we convert TEXT to Date/Time ?</P> Thu, 23 Sep 2021 12:07:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-format-different-time-amp-date-zone-into-EST/m-p/2094219#M47719 Manasi25 2021-09-23T12:07:16Z