https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Fiscal-Year-Table-issue/m-p/2986459#M100248 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="480208" data-lia-user-login="Revealer" class="lia-mention lia-mention-user">Revealer</a>&nbsp;</P><P>new table = calendar(min(Table[entrydate]),max(Table[entrydate]))</P><P>&nbsp;</P><P>If this post helps, please consider accept as solution to help other members find it more quickly.</P> Fri, 23 Dec 2022 12:41:10 GMT Mahesh0016 2022-12-23T12:41:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Fiscal-Year-Table-issue/m-p/2985764#M100193 <P>Hi i have&nbsp; entrydate column from 2019-2022 for changing to fiscal table i have used&nbsp;&nbsp;calendar auto(03) Dax query&nbsp;</P><P>column created from2007-2022 is coming.without creating <SPAN>separate</SPAN> table Fiscal year is coming correctly .</P> Fri, 23 Dec 2022 06:06:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Fiscal-Year-Table-issue/m-p/2985764#M100193 Revealer 2022-12-23T06:06:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Fiscal-Year-Table-issue/m-p/2986459#M100248 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="480208" data-lia-user-login="Revealer" class="lia-mention lia-mention-user">Revealer</a>&nbsp;</P><P>new table = calendar(min(Table[entrydate]),max(Table[entrydate]))</P><P>&nbsp;</P><P>If this post helps, please consider accept as solution to help other members find it more quickly.</P> Fri, 23 Dec 2022 12:41:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Fiscal-Year-Table-issue/m-p/2986459#M100248 Mahesh0016 2022-12-23T12:41:10Z