topic Re: Calendar function shows weird dates outside of the date ranges given in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calendar-function-shows-weird-dates-outside-of-the-date-ranges/m-p/2548116#M72028 <P>That's not a valid way of specifying a date. Try</P><LI-CODE lang="markup">SEL = CALENDAR( DATE(2014, 1, 1), DATE(2022, 12,31))</LI-CODE> Mon, 30 May 2022 15:17:18 GMT johnt75 2022-05-30T15:17:18Z Calendar function shows weird dates outside of the date ranges given https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calendar-function-shows-weird-dates-outside-of-the-date-ranges/m-p/2547971#M72016 <P>I am trying to use the calendar function for dates in 2022</P><P>result is 25-6-1894 to 6-7-1894 dates</P><P>weird..anyone has a solution..why this is happening</P><P>&nbsp;</P><DIV><DIV><SPAN>SEL = </SPAN><SPAN>CALENDAR</SPAN><SPAN> (</SPAN><SPAN>01</SPAN><SPAN>-</SPAN><SPAN>01</SPAN><SPAN>-</SPAN><SPAN>2014</SPAN><SPAN>, </SPAN><SPAN>31</SPAN><SPAN>-</SPAN><SPAN>12</SPAN><SPAN>-</SPAN><SPAN>2022</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV></DIV><P>&nbsp;</P> Mon, 30 May 2022 13:52:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calendar-function-shows-weird-dates-outside-of-the-date-ranges/m-p/2547971#M72016 kirpalas 2022-05-30T13:52:41Z Re: Calendar function shows weird dates outside of the date ranges given https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calendar-function-shows-weird-dates-outside-of-the-date-ranges/m-p/2548116#M72028 <P>That's not a valid way of specifying a date. Try</P><LI-CODE lang="markup">SEL = CALENDAR( DATE(2014, 1, 1), DATE(2022, 12,31))</LI-CODE> Mon, 30 May 2022 15:17:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calendar-function-shows-weird-dates-outside-of-the-date-ranges/m-p/2548116#M72028 johnt75 2022-05-30T15:17:18Z Re: Calendar function shows weird dates outside of the date ranges given https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calendar-function-shows-weird-dates-outside-of-the-date-ranges/m-p/2548967#M72074 <P>Thanks for the reply and solution..it works.. the manual showed start date, enddate</P> Tue, 31 May 2022 04:38:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calendar-function-shows-weird-dates-outside-of-the-date-ranges/m-p/2548967#M72074 kirpalas 2022-05-31T04:38:20Z