https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calendar-CalendarAuto-limited-to-today-s-year-month-day/m-p/2734547#M83845 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="395167" data-lia-user-login="Joseph_Hchaime" class="lia-mention lia-mention-user">Joseph_Hchaime</a>&nbsp;</P> <P><img /></P> <LI-CODE lang="javascript">CALENDAR = FILTER ( CALENDARAUTO(), [Date] &lt;= TODAY () )</LI-CODE> Tue, 30 Aug 2022 08:31:23 GMT tamerj1 2022-08-30T08:31:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calendar-CalendarAuto-limited-to-today-s-year-month-day/m-p/2734494#M83840 <P>How can I limit the creation of a dates table using the auto calendar dax function but limited to today's date only? i tried that but it gave me to the end of the current year.&nbsp;</P> Tue, 30 Aug 2022 08:14:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calendar-CalendarAuto-limited-to-today-s-year-month-day/m-p/2734494#M83840 Joseph_Hchaime 2022-08-30T08:14:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calendar-CalendarAuto-limited-to-today-s-year-month-day/m-p/2734547#M83845 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="395167" data-lia-user-login="Joseph_Hchaime" class="lia-mention lia-mention-user">Joseph_Hchaime</a>&nbsp;</P> <P><img /></P> <LI-CODE lang="javascript">CALENDAR = FILTER ( CALENDARAUTO(), [Date] &lt;= TODAY () )</LI-CODE> Tue, 30 Aug 2022 08:31:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calendar-CalendarAuto-limited-to-today-s-year-month-day/m-p/2734547#M83845 tamerj1 2022-08-30T08:31:23Z