https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CYYDDD-conversion-to-calendar-date/m-p/3147715#M112671 <P>I am not able to convert the CYYDDD julian date to calendar date.</P><P>Can anybody help?</P> Wed, 22 Mar 2023 16:08:13 GMT kkhajanchi 2023-03-22T16:08:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CYYDDD-conversion-to-calendar-date/m-p/3147715#M112671 <P>I am not able to convert the CYYDDD julian date to calendar date.</P><P>Can anybody help?</P> Wed, 22 Mar 2023 16:08:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CYYDDD-conversion-to-calendar-date/m-p/3147715#M112671 kkhajanchi 2023-03-22T16:08:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CYYDDD-conversion-to-calendar-date/m-p/3147796#M112678 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="534405" data-lia-user-login="kkhajanchi" class="lia-mention lia-mention-user">kkhajanchi</a>&nbsp;</P> <P>assuming dates are in the 2000 +<BR />Date =<BR />DATE ( 2000 + VALUE ( LEFT ( 'Table'[JD], 2 ) ), 1, 1 )<BR />+ VALUE ( RIGHT ( 'Table'[JD], 3 ) )<BR /><BR /></P> Wed, 22 Mar 2023 16:35:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CYYDDD-conversion-to-calendar-date/m-p/3147796#M112678 tamerj1 2023-03-22T16:35:52Z